T-SQL Querying

by Itzik Ben-Gan, Adam Machanic, Dejan Sarka

Updating both Inside Microsoft SQL Server 2008 T-SQL Querying (Microsoft Press, 2009) and parts of Inside Microsoft SQL Server 2008 T-SQL Programming (Microsoft Press, 2009), the book gives database developers and administrators a detailed look at the internal architecture of T-SQL and a comprehensive programming reference. 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. The book covers many unique techniques that were developed, improved, and polished by the authors over many years of experience, providing highly efficient solutions for common challenges. There's a deep focus on the performance and efficiency of the techniques and solutions that are covered. The book emphasizes correct understanding of the language and its underlying mathematical foundations.

Genres: Reference, Programming, Technical

864 pages, Paperback

First published January 30, 2015

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

[Dale Spivak · Rating 4 out of 5]

Great for understanding how queries are processed and how using different logic or methodology can expedite query process

[Delhi Irc]

Location: GG6 IRC
Accession No: DL028802