- Recorded Date:Jul. 9, 2020
- Event:On Demand
At some point, you'll run into a query that’s written decently but it just doesn't perform well with the plan SQL Server generates. When that happens, you may have a bad day for what seems like no reason at all.
In this on demand session, you’ll see 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. Determining when to use Query Store versus a plan guide isn’t 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!