Get Your Optimizer to Give Up All Its Secrets

Dive deep into the intricacies of SQL Server query optimization in this illuminating one-hour conference talk from PASS Data Community Summit. Uncover the hidden processes behind execution plan generation, exploring how SQL Server transforms T-SQL statements into internal tree structures and applies efficiency-enhancing rules. Learn to extract valuable optimization data, including parse trees and memos, directly from SQL Server. Gain insights into the strengths and potential shortcomings of the optimization process, empowering you to craft more efficient SQL statements. Enhance your database performance tuning skills by understanding the inner workings of the SQL Server optimizer.