MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

Chapter 1: Designing a Data Access Strategy

Table 1-1: Recommended Uses for Data Providers

Table 1-2: Namespaces and Objects Used to Connect to Data Sources

Chapter 2: Designing Database Queries

Table 2-1: Data Providers Available for Linked Servers

Table 2-2: Query Results When Using the PIVOT Operator

Table 2-3: Query Results When Using the APPLY Operator

Table 2-4: Query Results When Using the ROW_NUMBER Function

Table 2-5: Built-in Aggregate Functions

Table 2-6: Partial Query Results After Executing First SELECT Statement

Table 2-7: Query Results When Using the Query in Exercise 1

Chapter 3: Designing a Cursor and Caching Strategy

Table 3-1: Attributes of the OutputCache Directive

Chapter 4: Advanced Query Topics

Table 4-1: Server Management Object (SMO) Namespaces

Chapter 7: Optimizing SQL Server 2005 Performance

Table 7-1: Theoretical Execution Order - Excluding the UNION Clause

Table 7-2: Theoretical Execution Order - Including the UNION Clause

Table 7-3: Items from the Graphical Execution Plan

Test TableA

Table 7-4: Query Performance Matrix

Table 7-5: Index Size Matrix

Table 7-6: Levels of the NoIncludedColumns Index

Table 7-7: Levels of the IncludedColumns Index

Table 7-8: Levels of the IncludedColumns Index

Table 7-9: Subset of the sys.dm_db_index_usage_stats DMV

Chapter 8: Improving Database Application Performance

Table 8-1: Advantages and Disadvantages of Scale-Out Techniques

Table 8-2: Partition Function Catalog Views

Table 8-3: Templates Included with SQL Server Profiler

Table 8-4: Default Performance Counters for System Monitor

Table 8-5: Performance Counters Recommended by Microsoft for Performance Baseline

Table 8-6: Key Counters for Diagnosing Problems

Table 8-7: Key Dynamic Management Views for Diagnosing Problems

Appendix B: SQL Server 2005 Architecture and Internals

Table B-1: CLR Host Assembly Permissions