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 array using concatenation

Figure 2. RAID 0 array using striping

Figure 3. RAID 1 array

Figure 4. Poor disk alignment

Figure 5. Correct disk alignment

Chapter 6. Generalization: the key to a well-designed schema

Figure 1. Broad versus narrow and specific

Figure 2. Common Object table organized by the ObjectType table

Chapter 8. Page restores

Figure 1. Backup history

Figure 2. You’ll perform a page-level restore.

Figure 3. Specify the pages you want to restore.

Chapter 12. Build your own SQL Server 2008 performance dashboard

Figure 1. Creating a new project based on the SQL Server Project template in Visual Studio 2008 Professional

Figure 2. The Properties window with the AutoRefresh property of the report set to 10 seconds