Inside Microsoft® SQL Server® 2008: T-SQL Querying

Inside Microsoft® SQL Server® 2008: T-SQL Querying

<p>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.<br /> <br /> </p> <p>Discover how to:<br /> <br /> </p> <ul> <li>Move from procedural programming to the language of sets and logic</li> <li>Optimize query tuning with a top-down methodology </li> <li>Assess algorithmic complexity to predict performance</li> <li>Compare data-aggregation techniques, including new grouping sets </li> <li>Manage data modification—insert, delete, update, merge—for performance</li> <li>Write more efficient queries against partitioned tables</li> <li>Work with graphs, trees, hierarchies, and recursive queries</li> <li>Plus—Use pure-logic puzzles to sharpen your problem-solving skills</li> </p>