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.
Overview
Syllabus
Introduction
Example
Interleave Execution
Inline Table Value
Multiline
Memory Grant Feedback
Memory Grant Feedback Example
Table Variable Deferred Compilation
Adventure Works
Batch Mode on Rowstore
Scalar UDF Inlining
Scalar UDF Demo
Approximate Count Distinct
Controlling IQP Features
Missing Table Example
Taught by
PASS Data Community Summit
