Jan
5
2008
ROWCOUNT(), You Are My Hero!
I’ll go into the details and some sample code later, I have a bit of a crisis on my hands right now, but in short the ROWCOUNT() feature in SQL 2005 ROCKS!
I just got my queries down from 40-50 seconds (i think that’s the prob I’ve been having) to 183 milliseconds! Hells Yeah!
More on this awesomeness later =)