Intelligent Query Processing
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
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.
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
Related Courses
Doing More with Less - The Challenges Ahead for Every Data ProfessionalPASS Data Community Summit via YouTube Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube Transform Your Data Estate
PASS Data Community Summit via YouTube Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube