Explore the self-tuning capabilities of SQL Server 2019 in this 57-minute conference talk from the PASS Data Community Summit. Dive into adaptive query processing features and Query Store's automatic plan regression fixes. Learn about Intelligent Query Processing, Adaptive Joins, Interleaved Execution, Memory Grant Feedback, Table Variable Deferred Compilation, Scalar Function Inlining, and Approximate Query Processing. Gain valuable insights into optimizing database performance and efficiency through SQL Server's advanced self-tuning mechanisms.
Overview
Syllabus
Intro
Technical Assistance
Thank you to our Presenting Sponsors
Intelligent Query Processing
Adaptive Joins
Interleaved Execution
Memory Grant Feedback
Table Variable Deferred Compilation
Scalar Function Inlining
Approximate Query Processing
Taught by
PASS Data Community Summit
Related Courses
-
Intelligent Query Processing
-
Intelligent Database Futures in Azure SQL and SQL Server 2022 - Data Exposed Live
-
SQL Server and Azure SQL Database Intelligent Query Performance
-
SQL Server 2017 Database Engine Enhancements - Why You Should Upgrade to It
-
Built-in Intelligence with Azure SQL and SQL Server 2022 - Intelligent Query Processing and Database Features
