Query Store Hints, how can it help in performance issues?

Hi there!

Last December I got lucky since after upgrading from SQL Server 2012 to 2022, one of my clients had a process running in a particular database that went from around 10 minutes to around 10 hours!

You might be thinking: “It got 60 times worse, where’s the luck in that?”

Well, it presented me with a great opportunity to try a new feature in SQL Server 2022 called “Query Store Hints” (in a real production environment) and confirm the fabulous results that can be obtained by using it, with no effort at all. I thought it could be worth to share this experience and that’s what I’ll present in this post 🙂

What’s wrong with these row estimates?!

Hi there!

When you’re watching an execution plan while fine tuning a query, one of the (many) things that you usually look at are the “Estimated Number of Rows” vs “Actual Number of Rows” and the closer they are, the happier you get 🙂