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


Quest sponsored on-demand webinar




Download slides and scripts!




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






Learn more about SQL Server tools