Inside Microsoft SQL Server 2008: T-SQL Querying

by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka

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

Genres: Programming, Reference, Technical

798 pages, Paperback

First published March 25, 2009

About the author

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions and Microsoft SQL Server 2012 T-SQL Fundamentals. He has written articles for SQL Server Pro, SolidQ Journal and MSDN. Itzik's speaking activities include TechEd, SQLPASS, SQLU, SQLTeach and various user groups around the world. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.

Itzik Ben-Gan is a co-founder of Solid Quality Mentors, a technical education company, and is a Microsoft SQL Server MVP.

Reviews

[Rachel · Rating 5 out of 5]

Deep dive into the internals of SQL Server 2008 with this excellent tome from the ever reliable Itzik Ben-Gan. A tough read but ultimately rewarding, this book exposes the SQL Server optimizer and teaches you how to tame the beast.

[Josh Imdacha · Rating 3 out of 5]

select * from CompleteBoredom
where I = 'Bored'

[Lolo · Rating 5 out of 5]

epic book