isuckatsql (10/4/2013)
Sean, you make a lot of suggestions about all the things i am doing wrong, yet offer nothing helpful.This is a discussion forum, so we discuss things, if you don't want to help then don't, but it serves no purpose to turn it into a pi**ing contest.
Nothing helpful, like his suggestion on how to do catch all queries, the question about the ramification of nolock, the question about the correlated subqueries (most of which you ignored)?
I'm personally getting the opinion you want verification you're right, not help, so I'm done here.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability