Inside Microsoft SQL Server(tm) 2005: T-SQL Querying

Take a detailed look at the internal architecture of T-SQL--and unveil the power of set-based querying--with comprehensive reference and advice from the experts. Database developers and administrators get best practices, sample databases, and code to master the intricacies of the programming language--solving complex problems with real-world solutions.

Discover how to: Understand logical and physical query processingApply a methodology to optimize query tuningSolve relational division problemsUse CTEs and ranking functions to simplify and optimize solutionsAggregate data with various techniques, including tiebreakers, pivoting, histograms, and grouping factorsUse the TOP option in a query to modify dataQuery specialized data structures with recursive logic, materialized path, or nested sets solutionsPLUS--Improve your logic and get to the heart of querying problems with logic puzzles

Get code and database samples on the Web