SQL Server MVP Deep Dives

List of Figures

Chapter 3. Finding functional dependencies

Figure 1. A mocked-up database diagram makes it immediately obvious that this foreign key isn’t allowed.

Figure 2. A sample order confirmation form

Figure 3. Sample order confirmation modified to find which attributes depend on OrderNo

Chapter 7. Pulling apart the FROM clause

Figure 1. Identical query plans demonstrating the breakdown of the view

Figure 2. A much simpler execution plan involving only one table

Figure 3. A nonclustered index being used

Figure 4. The ProductSubcategory table being used again

Figure 5. This execution plan is simpler because NULLs are not being introduced.

Chapter 8. What makes a bulk insert a minimally logged operation?

Figure 1. Bulk Insert Task Editor ...