Chapter 1. Logical Query Processing
Logical Query Processing Phases
Sample Query Based on Customers/Orders Scenario
Logical Query Processing Phase Details
New Logical Processing Phases in SQL Server 2005
Conclusion
Chapter 2. Physical Query Processing
Flow of Data During Query Processing
Compilation
Conclusion
:: Course ::
Chapter 3. Query Tuning
Sample Data for This Chapter
Tuning Methodology
Tools for Query Tuning
Index Tuning
Preparing Sample Data
An Examination of Set-Based vs. Iterative/Procedural Approaches, and a Tuning Exercise
Additional Resources
Conclusion
Chapter 4. Subqueries, Table Expressions, and Ranking Functions
Subqueries
Table Expressions
Analytical Ranking Functions
Auxiliary Table of Numbers
Existing and Missing Ranges (Also Known as Islands and Gaps)
Conclusion
Chapter 5. Joins and Set Operations
Joins
Set Operations
Conclusion
:: Course ::
Chapter 6. Aggregating and Pivoting Data
OVER Clause
Tiebreakers
Running Aggregations
Pivoting
Unpivoting
Custom Aggregations
Histograms
Grouping Factor
CUBE and ROLLUP
Conclusion
Chapter 7. TOP and APPLY
SELECT TOP
APPLY
Solutions to Common Problems Using TOP and APPLY
Conclusion
Chapter 8. Data Modification
Inserting Data
Deleting Data
Updating Data
Other Performance Considerations
Conclusion
:: Course ::
Chapter 9. Graphs, Trees, Hierarchies, and Recursive Queries
Terminology
Scenarios
Iteration/Recursion
Materialized Path
Nested Sets
Transitive Closure
Conclusion
Appendix A. Logic Puzzles
Puzzles
Puzzle Solutions
Conclusion
About the Contributors
Index
Programme scope, delivery arrangements and suitability are confirmed during enquiry.