Grant's suggestion is a good one but a keynote in the dissertation should include the fact that automation should never be used as a substitute for knowledge because if you...

Sure but my system at work won't allow me to post what I...

To add to what Lynn correctly stated, there's a hidden overhead that most people don't even know about and those are the effects of "Bad" page splits on the log...

Shifting gears to TRY/CATCH, I think that the way a lot of people use it is wrong, especially in the presence of SET XACT_ABORT ON.  Might be worth an article...

Understood on all of that but it is a tool and if you ever need it, you would like it to be available. 

I will admit that I've...