Technical details
Mac compatibility |
N |
Number of pages |
798 pages |
Written by |
Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass |
Inside Microsoft SQL Server 2008: T-SQL Querying
Master the mechanics behind advanced querying and tuning - for faster, more scalable code
Tackle the toughest set-based querying and 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.
Delve into the internal architecture of T-SQL - and unveil the power of set-based querying - with reference & advice from a highly regarded T-SQL expert and members of Microsoft's SQL Server development team.
Database developers and administrators will examine the best practices, advanced techniques, sample databases, and code needed to master the programming language built into SQL Server - solving complex problems with real-world solutions.- Understand logical & physical query processing;
- Learn about set theory, predicate logic, and the relational model;
- Apply a methodology to optimize query tuning;
- Analyze the algorithmic complexity of your queries;
- Solve relational division problems;
- Use CTEs and ranking functions to simplify & optimize solutions;
- Aggregate data with various techniques, including tiebreakers, pivoting, histograms, grouping factors, & grouping sets;
- Use the TOP option to query and modify data;
- Use the MERGE statement to modify data based on conditional logic;
- Maintain & query graph structures with the HIERARCHYID datatype, recursive queries, and other solutions;
- PLUS - Improve your logic & get to the heart of querying problems with logic puzzles.