The Real Self-Tuning Database

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.