Query Store, Plan Forcing, and DROP/CREATE

,

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.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

Share

Share

Rate