On occasion you might find a query that doesn’t perform consistently or just not at all.  When you don’t have consistent query performance you might consider forcing a plan with query store.  Similarly, if you’re trying to influence a plan that doesn’t behave the way you think it should you can apply a plan guide. […]