Built-in Intelligence with Azure SQL and SQL Server 2022 - Intelligent Query Processing and Database Features
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only! Grab it Explore the built-in intelligence features of Azure SQL and SQL Server 2022 in this 50-minute SQLBits conference talk. Dive into the Intelligent query processing feature family, including improvements to memory grant feedback, degree of parallelism (DOP) feedback, and parameter sensitive plan optimization. Discover how these features enhance business-critical workloads without requiring application code changes. Examine the intelligent database feature family, database compatibility levels, and learn troubleshooting techniques using query store hints. Gain insights from speaker David Pless as he covers topics such as Query Store custom capture policies, applying Query hints, Parameter Sensitivity Plan optimization, Memory Grant Feedback, Cardinality Estimation feedback, and Optimized Plan Forcing using Query Store.