Explore groundbreaking enhancements in Intelligent Query Processing for SQL Server 2019 and Azure SQL Database in this conference talk from PASS Data Community Summit. Delve into Microsoft's mission to improve critical parallel workloads at scale while adapting to the evolving data landscape. Learn about anxiety-free upgrades, memory grant feedback, query execution plans, and batch mode processing. Discover the benefits of adaptive thresholds, initial overhead considerations, compatibility levels, and adaptive joins. Gain insights into regression prevention, reporting thresholds, and the intelligent database world that began with SQL Server 2017 and advances significantly in SQL Server 2019 and Azure SQL Database.
SQL Server and Azure SQL Database Intelligent Query Performance