Using SQL Server Query Store & Plan Guides to Fix Problem Queries


Quest sponsored on-demand webinar

Webcast Abstract

Sooner or later you'll run into a query that is written decently but doesn't perform well with the plan that SQL Server generates. When that happens you can be having a bad day for what seems like no reason at all.

This presentation will show you how to "fix" a problem by adding or removing a hint (without changing the statement) or by specifying a different query plan. It's not magic, you have to figure out what behavior would be better and know whether the Query Store or a plan guide is the better option for making it happen. It's also not quite intuitive, but it's doable once you know how. We're going to start at the beginning and cover how to use both as we fix a couple queries gone bad!

Speaker - Andy Warren

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.





download





get free sql tips
agree to terms


Learn more about SQL Server tools