- 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!
Andy Warren is a SQL Server consultant based in Orlando. Andy was a founding principal of SQLServerCentral.com, is the former President of the Orlando SQL Server Users Group, and one of the founders of SQLSaturday. He has been an MVP since 2009 and has written and presented extensively SQL Server. Andy blogs at www.sqlandy.com, is on LinkedIn at www.linkedin.com/in/sqlandy, and is occasionally on Twitter as @SQLAndy.