In this episode of Data Exposed,Joe Sack, Principal Group Program Manager of SQL Server engine and SQL Hybrid, or Anna Hoffman,Data & Applied Scientist, talk approximately 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, or which leverages queries already captured in Query Store to apply hints that would beget originally required modifications to the original query text through the OPTION clause.[00:32] Introduction
[01:10] What are Query Hints?
[03:10] Applying Query Hints today
[04:26] Introducing Query Store Hints
[05:07] How to use Query Store Hints - Step 1
[05:46] How to use Query Store Hints - Step 2
[06:36] Demo
[12:10] Query Store tip Scope and Behavior
[14:10] Use-cases for Query Store HintsFeedback? Email QSHintsFeedback@microsoft.com [http://m.webtrends.com/dcs1wotjh10000w0irc493s0e_6x1g/njs.gif?dcssip=channel9.msdn.com&dcsuri=https://channel9.msdn.com/Feeds/RSS&WT.dl=0&WT.entryid=Entry:RSSView:bb59864f38ea4c23b578acbd00f9da35]
Source: msdn.com