SQL Server MVP Deep Dives, Volume 2

List of Figures

Chapter 2. “Yes, we are all individuals” A look at uniqueness in the world of SQL

Figure 1. Gold key icons are used to indicate primary keys.

Figure 2. Blue key icons are used to indicate unique constraints.

Figure 3. Comparing DISTINCT and GROUP BY

Figure 4. The sort operation disappears with an extra column.

Figure 5. The Sort operation reappears when the uniqueness isn’t already known.

Figure 6. Counting the number of products sold by product name and color, using a unique constraint

Figure 7. Counting the number of products sold by product name and color, without using a unique constraint

Figure 8. Counting the number of products sold, grouping by the primary key

Chapter 5. Storage design considerations

Figure 1. RAID 0 ...