I can smell your parameters from here
You swear nothing has changed, but all of a sudden, out of nowhere, queries that used to be fast are suddenly slow. Even weirder, you take the slow query from the application, run it in SSMS, and it’s totally fast! What’s going on?
You restart SQL Server or update statistics, and the problem seems to go away – but only for a few days or weeks, and then it comes right back. You’re familiar enough with execution plans to realize that you’re getting different plans, but…why? And how do you fix it long