Intelligent Query Processing
Explore the advancements in SQL Server's Intelligent Query Processing (IQP) in this 58-minute conference talk from PASS Data Community Summit. Learn about optimizer enhancements that address common anti-patterns in T-SQL, including improvements for table variables and user-defined functions. Discover when these features can boost performance without code changes and when they may fall short. Dive into topics such as Interleaved Execution, Inline Table Value, Memory Grant Feedback, Table Variable Deferred Compilation, Batch Mode on Rowstore, Scalar UDF Inlining, and Approximate Count Distinct. Gain insights on controlling IQP features and see practical examples using Adventure Works database. Enhance your understanding of SQL Server query optimization techniques to improve database performance.