I absolutely love Query Store and the ability it provides to force a plan is amazing. However, there are a lot of little gotchas in this functionality. I just recently found one that has quite a far reaching effect. Let’s talk about what happens when you DROP and then CREATE a stored procedure. Query Store […]
The post Query Store, Plan Forcing, and DROP/CREATE appeared first on Grant Fritchey.