Inside Microsoft SQL Server 2008: T-SQL Querying

Description

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 techniques, including new grouping sets
* Manage data modification - insert, delete, update, merge - for performance
* Write more efficient queries against partitioned tables
* Work with graphs, trees, hierarchies, and recursive queries
* Plus - Use pure-logic puzzles to sharpen your problem-solving skills

CONTENTS:

ForewordAcknowledgmentsIntroductionChapter 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