Query Store Hints in Azure SQL Database | Data Exposed

Published 06-10-2021 09:00 AM 682 Views
Microsoft

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.

 

Watch on Data Exposed


Feedback? 
Email QSHintsFeedback@microsoft.com

View/share our latest episodes on Channel 9 and YouTube!
%3CLINGO-SUB%20id%3D%22lingo-sub-2417604%22%20slang%3D%22en-US%22%3EQuery%20Store%20Hints%20in%20Azure%20SQL%20Database%20%7C%20Data%20Exposed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2417604%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EIn%20this%20episode%20of%20Data%20Exposed%2C%20Joe%20Sack%2C%20Principal%20Group%20Program%20Manager%20of%20SQL%20Server%20engine%20and%20SQL%20Hybrid%2C%20and%20Anna%20Hoffman%2C%20Data%20%26amp%3B%20Applied%20Scientist%2C%20talk%20about%20a%20new%20way%20in%20Azure%20SQL%20Database%20to%20optimize%20the%20performance%20of%20queries%20when%20you%20are%20unable%20to%20directly%20change%20the%20original%20query%20text.%20They%20will%20cover%20the%20new%20public%20preview%20feature%20Query%20Store%20Hints%2C%20which%20leverages%20queries%20already%20captured%20in%20Query%20Store%20to%20apply%20hints%20that%20would%20have%20originally%20required%20modifications%20to%20the%20original%20query%20text%20through%20the%20OPTION%20clause.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CFONT%20size%3D%225%22%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FpYB6Uik_Q7A%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EWatch%20on%20Data%20Exposed%3C%2FA%3E%3C%2FFONT%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%3E%3CEM%3E%3CBR%20%2F%3EFeedback%3F%26nbsp%3B%3C%2FEM%3EEmail%20QSHintsFeedback%40microsoft.com%3C%2FDIV%3E%0A%3CDIV%3E%0A%3CDIV%3E%3CBR%20%2F%3E%3CSPAN%3EView%2Fshare%20our%20latest%26nbsp%3Bepisodes%20on%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fchannel9.msdn.com%2FShows%2FData-Exposed%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EChannel%209%3C%2FA%3E%3CSPAN%3E%26nbsp%3Band%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fplaylist%3Flist%3DPLlrxD0HtieHieV7Jls72yFPSKyGqycbZR%26amp%3BWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EYouTube%3C%2FA%3E%3CSPAN%3E!%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2417604%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MSDataExposed.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202729i490928FF0C962B7B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MSDataExposed.jpg%22%20alt%3D%22MSDataExposed.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EWant%20to%20learn%20more%20about%20query%20store%20hints%20in%20Azure%20SQL%20Database%3F%20Learn%20more%20on%20Data%20Exposed.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2417604%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%20Database%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Jun 04 2021 01:04 PM
Updated by: