Query Store Hints in Azure SQL Database | Data Exposed

From the creator

In this episode of Data Exposed, Joe Sack, Principal Group Program Manager of SQL Server engine and SQL Hybrid, and Anna Hoffman, Data & Applied Scientist, talk about a new way in Azure SQL Database to optimize the performance of queries when you are unable to directly change the original query text. They will cover the new public preview feature Query Store Hints, which leverages queries already captured in Query Store to apply hints that would have originally required modifications to the original query text through the OPTION clause. 0:00 Show begins 0:32 Introduction 1:10 What are Query Hints? 3:10 Applying Query Hints today 4:26 Introducing Query Store Hints 5:07 How to use Query Store Hints - Step 1 5:46 How to use Query Store Hints - Step 2 6:36 Demo 12:10 Query Store Hint Scope and Behavior 14:10 Use-cases for Query Store Hints ✔️ Resources: Query Store Hints Preview: https://techcommunity.microsoft.com/t5/azure-sql/query-store-hints-preview/ba-p/2424378?WT.mc_id=dataexposed-c9-niner Feedback? Email [email protected] 📌 Let's connect: Twitter - Joe Sack, https://twitter.com/JoeSackMSFT Twitter - Anna Hoffman, https://twitter.com/AnalyticAnna Twitter - AzureSQL, https://aka.ms/azuresqltw 🔴 To watch even more Data Exposed episodes, check our playlist: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Develope

Published 2021-06-10 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.