Put Out I see people using OUTPUT to audit modifications from time to time, often because “triggers are bad” or…
Options Ahoy There are lots of great options out there for figuring out what’s happening on a server. If you’re…
Well, huh
Harkening In dramatic fashion, I’m revisiting something from this post about stats updates. It’s a quick post, because uh… Well.…
Many Have Entered, Few Have Left For some background on Exchange Spills, check out this Great Post™ by Joe. The…
Don’t Want None One of the many current downsides of @table variables is that modifying them inhibits parallelism, which is…
Goal Posts When you’re measuring query changes to see if your performance changes have made a difference, a common way…
Absence Of Evidence There’s a pinky-out saying about wine: don’t hate the grape. People say it because the same kind…
Mr. Duster
Memethread