At some point, you'll encounter a query that’s written decently but just doesn't perform well with the plan SQL Server generates. When that happens, you may have a frustrating day for what seems like no reason at all. In this on-demand session, you’ll learn how to tackle these challenges by adding or removing a hint without changing the statement, or by specifying a different query plan. It's not magic; it’s about understanding the behavior that would work better and determining whether Query Store or a plan guide is the right tool for the job. We’ll start from the basics and cover how to use both as we fix a couple of queries gone bad!
Topics that will be discussed include:
- Identifying and fixing SQL Server query performance issues with hints
- Deciding between Query Store and plan guides for query plan adjustments
- Step-by-step process to implement and test query plan changes
- Practical examples of resolving common SQL Server query problems
Speaker: Andy Warren, SQL Server consultant and founder of SQLServerCentral.com, Blog, LinkedIn