Publisher's Synopsis
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
