|
Inside Microsoft SQL Server 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 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
CONTENTS:
Logical query processing
Physical query processing
Query tuning
Subqueries
Joins
Pivoting data
Data modification
Graphs & trees
|
