GilaMonster (10/5/2013)
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,
I responded to his comment about correlated subqueries with Joins, and it was slower!
I know the pros and cons of NOLOCK.
I was looking for faster count assistance, which Sean did not help me with, all he wanted to do was tell me how bad the query was, and how i wasted thousands of dollars on unqualified DBA's, both of which are wrong!
Anyone can picks things apart, its the smart ones that offer solutions!
I have ended up getting far more productive answers on Google than i have here, which has sadly been very typical of this site.
I periodically come back, but a lot of the 'attitude' remains, which sadly is common among IT people!
Have you heard the term "pay it forward" ?