Tackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals—and gain practical approaches and advanced techniques to optimize your code’s performance.\ Discover how to:\ \ Move from procedural programming to the language of sets and logic\ Optimize query tuning with a top-down methodology\ Assess algorithmic complexity to predict performance\ Compare data-aggregation...
Comprehensive hands-on reference focuses on advanced querying techniques using Transact-SQL (T-SQL). For database developers & adminstrators. Includes code & table examples.
ForewordAcknowledgmentsIntroduction Chapter 1: Logical Query ProcessingChapter 2: Set Theory and Predicate LogicChapter 3: The Relational ModelChapter 4: Query TuningChapter 5: Algorithms and ComplexityChapter 6: Subqueries, Table Expressions, and Ranking FunctionsChapter 7: Joins and Set OperationsChapter 8: Aggregating and Pivoting DataChapter 9: TOP and APPLYChapter 10: Data ModificationChapter 11: Querying Partitioned TablesChapter 12: Graphs, Trees, Hierarchies, and Recursive QueriesAppendix A: Logic PuzzlesAbout the Authors