Edit: November 12, 2020 – Updated information about Query Store performance overhead can be found in this post. “What is the performance overhead of enabling
I recently had a scenario in a two-node Availability Group where multiple large-batch modification queries were executed and created a large redo queue on the
This is question I’ve gotten a few times in class…Can you force a plan for a different query with Query Store? tl;dr No. Assume you
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.