New from Brent Ozar on Query So Slow.
You’re testing a query, and you’re just not getting the same performance between the development and production servers. There’s a huge list of common things that might be causing it: Parameter sniffing Different database-level settings like compatibility levels and cardinality…