List of Tables

Chapter 3. Finding functional dependencies

Table 1. Sample data in tabular format

Table 2. Changing the data in the second row to find what attributes depend on OrderNo

Table 3. Another set of changed data, this time to test dependencies for CustomerName

Table 4. Testing functional dependencies for CustomerID

Table 5. Testing functional dependencies for Product

Table 6. Testing functional dependencies for Qty

Table 7. Testing functional dependencies for TotalPrice

Table 8. Testing functional dependencies for OrderTotal

Table 9. Testing functional dependencies for the combination of OrderNo and Product

Table 10. Testing functional dependencies for the combination of CustomerID and OrderTotal

Chapter 5. Gaps and islands

Table 1. Desired result for gaps problem

Table 2. Desired result for islands problem

Table 3. Performance summary of solutions to gaps problem

Table 4. Desired result for variation on the islands problem

Table 5. Performance summary of solutions to islands problem

Chapter 6. Error handling in SQL Server and applications

Table 1. SQLException class properties

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

Table 1. Resultant log file sizes

Chapter 10. Introduction to XQuery on SQL Server

Table 1. XML data type methods summary

Table 2. XQuery comparison operators

Chapter 11. SQL Server XML frequently asked questions

Table 1. Predeclared XML entities

Chapter 12. Using XML to transport relational data