Database Training Days 101: Using SQL Server Query Store and Plan Guides to Fix Problem Queries with

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