Etienne Lopes shares some thoughts around a new feature in SQL Server 2022:
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
Click through for more details on the problem and solution.