Sign in to confirm you’re not a bot
This helps protect our community. Learn more

SQL Server 2022: Accelerate query performance while reducing query compile time - w/ no code changes

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
2.4K views 1 year ago #SQLServer #AzureSQL
Learn more about the plan compilation features contained within SQL’s Intelligent Query Processing offering, how they work, what common scenarios benefit from them, and how to get the most from them. 00:20 - Introduction 00:44 - Optimized Plan Forcing explained 02: 45 - Phases 03:30 - Demo 07:40 - How to take advantage of this feature 11:05 - Cautions 12:15 - Closing ✔️ Resources: https://learn.microsoft.com/sql/relat... https://learn.microsoft.com/sql/relat... 📌 Let's connect: Twitter: Anna Hoffman,   / analyticanna​​​   Twitter: AzureSQL, https://aka.ms/azuresqltw​​​ 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQLServer ...more
...more
SQL Server 2022: Accelerate query performance while reducing query compile time - w/ no code changes
45Likes
2,446Views
2023Aug 24
Learn more about the plan compilation features contained within SQL’s Intelligent Query Processing offering, how they work, what common scenarios benefit from them, and how to get the most from them. 00:20 - Introduction 00:44 - Optimized Plan Forcing explained 02: 45 - Phases 03:30 - Demo 07:40 - How to take advantage of this feature 11:05 - Cautions 12:15 - Closing ✔️ Resources: https://learn.microsoft.com/sql/relat... https://learn.microsoft.com/sql/relat... 📌 Let's connect: Twitter: Anna Hoffman,   / analyticanna​​​   Twitter: AzureSQL, https://aka.ms/azuresqltw​​​ 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQLServer

Follow along using the transcript.

Microsoft Developer

588K subscribers