Itzik Ben-Gan, a Microsoft MVP for SQL Server since 1999, is among the world’s leading T-SQL consultants. Now, he’ll help you write T-SQL queries of exceptional power, and supercharge queries that already exist. From temporary tables to dynamic execution, his new book will give you mastery of advanced constructs many SQL Server programmers don’t dare to use.
Ben-Gan offers powerful insight into how SQL Server transforms logical queries into executable query plans -- and how to write code that generates far more efficient plans. He focuses heavily on set-based techniques but also covers cursors when they still make sense. Among this book’s many highlights: a systematic query tuning methodology he developed for his own company.
If you like what he’s done here -- and you will -- also check out his brand-new Inside Microsoft SQL Server 2005: T-SQL Programming, arguably the most useful advanced T-SQL programming reference ever written. Bill Camarda, from the June 2006 Read Only