Northwind is a simple database often used by people who want to learn SQL and that’s what we are going to use. The dataset consists of 13 tables that can be seen below: Later in this article, I’ll show how you can install this database on your local machine, using SQL Management Studio.
Table of contents
SQL performance tuningNorthwindSQL Query StressTips1. Fetch only the attributes needed2. Fetch only the records needed3. Take advantage of the NOT EXISTS4. Avoid using DISTINCT5. Know when to index6. Use wildcards wisely1 Comment
Sort: