A query that was fast yesterday is slow in production today. How do you debug it?

Answer preview

When a query that was fast yesterday is slow today, treat it as an incident: gather evidence before changing anything, because the cause is usually statistics, data volume, plan regression, lock wait, or infrastructure — not "the query changed."…