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

Table 1. Entities, the facts about them, and the roles those facts play in the business case

Table 2. Data management operations supported by our solution

Table 3. XPath expressions used to extract the entities from the Album XML

Table 4. XPath expressions used to extract the entities from the Band XML

Table 5. Retrieving the associative entities

Chapter 13. Full-text searching

Table 1. Simple ranking query results

Table 2. Results for medium-complexity ranking query

Table 3. Query results to list all full-text indexes

Table 4. Query results to list all columns that are full-text indexed

Table 5. Query results for catalog information query

Table 6. Sample of results for query to find keywords

Table 7. Sample of results for query to find keywords and their source row

Table 8. Partial results of expanded query combining keywords with source data

Chapter 14. Simil: an algorithm to look for similar strings

Table 1. Simil results for Pennsylvania

Chapter 18. Getting and staying connected—or not

Table 1. Typical server key settings

Table 2. Connection pooling connection string keywords

Chapter 21. Deprecation feature

Table 1. Deprecated features

Chapter 23. Mobile data strategies

Table 1. SyncAdapter properties

Table 2. SyncAdapter methods

Table 3. Synchronization agent properties

Table 4. TableCreationOption enumerations

Table 5. SyncDirection enumerations

Table 6. Key feature comparison of the three synchronization methodologies

Chapter 26. PowerShell in SQL Server

Table 1. PowerShell issues

Chapter 28. Practical auditing in SQL Server 2008

Table 1. Server Audit configuration settings for Application and Security Log targets

Table 2. Server audit configuration settings for File targets

Chapter 29. My favorite DMVs, and why

Table 1. DMV categories in SQL Server 2005 and 2008

Table 2. New DMV categories in SQL Server 2008

Chapter 38. Successfully implementing Kerberos delegation

Table 1. Free tools for testing and implementing

Table 2. Blog posts

Table 3. Microsoft TechNet articles

Table 4. Microsoft Help and Support articles pertaining to Kerberos delegation

Table 5. Microsoft white papers

Table 6. Microsoft webcasts

Chapter 39. Running SQL Server on Hyper-V

Table 1. Types and examples of virtualization technologies

Chapter 48. Query performance and disk I/O counters

Table 1. Test scripts to see the impact of small random I/Os

Table 2. Performance impact of small random I/Os

Table 3. Test scripts to see the impact of the NOLOCK hint

Table 4. Performance impact of the NOLOCK hint

Table 5. Test scripts to see the impact of the read-ahead operation

Table 6. Performance impact of the NOLOCK hint

Table 7. Performance impact of index fragmentation

Chapter 50. BI for the relational guy

Table 1. OLTP versus reporting environment characteristics

Chapter 53. SQL Server Audit, change tracking, and change data capture

Table 1. Comparing SQL Server Audit, change tracking, and change data capture

Chapter 54. Introduction to SSAS 2008 data mining

Table 1. SSAS 2008 data mining algorithms and usage

Chapter 55. To aggregate or not to aggregate—is there really a question?

Table 1. Aggregation example