T-SQL Querying: Inside Microsoft SQL Server 2005

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 processing * Apply a methodology to optimize query tuning * Solve relational division problems * Use CTEs and ranking functions to simplify and optimize solutions * Aggregate data with various techniques, including tiebreakers, pivoting, histograms, and grouping factors * Use the TOP option in a query to modify data * Query specialized data structures with recursive logic, materialized path, or nested sets solutions * PLUS-Improve your logic and get to the heart of querying problems with logic puzzles Get code and database samples on the Web