Joe Webb gave a presentation on “Tips & tricks for writing better queries” for the Nashville PASS chapter, and it’s a great read.  Developers and DBAs should all read this for a clear, concise refresher.

A video of the presentation would be even better, but for the most part, the slide deck speaks for itself.  Every bullet point is well-thought out – for example, “Be mindful of widely varying parameter inputs” – it doesn’t really explain why, but believe me – he’s right.  Been there, done that, got the t-shirt.