Viewing 15 posts - 18,226 through 18,240 (of 22,202 total)
Alvin Ramard (2/23/2009)
Jack Corbett (2/23/2009)
GSquared (2/23/2009)
Edit: Uh oh! I just realized I called "The Thread" "it"....
How else would you refer to The Thread? We do not the gender...
February 23, 2009 at 9:06 am
Or, to avoid system tables which can and do change:
SELECT COUNT(*)
FROM INFORMATION_SCHEMA.ROUTINES AS r
WHERE ROUTINE_TYPE = 'PROCEDURE'
February 23, 2009 at 6:32 am
I agree. I'd look at the execution plans. But you should also check the indexes on the two systems for differences in fragmentation. I'd also look at the statistics on...
February 23, 2009 at 6:26 am
Through our testing and long-term production maintenance on several systems using wider clustered indexes, I've found that fragmentation, even on systems with lots of inserts, is not that big a...
February 23, 2009 at 6:24 am
Kit G (2/21/2009)
February 21, 2009 at 7:31 am
And now I've spammed the endless thread.
Sorry everyone, sorry, I just got carried away.
February 21, 2009 at 4:30 am
Lynn Pettis (2/20/2009)
David Webb (2/20/2009)
So many AD&D players.
DM: The OP has just sprung from behind a large pile of unread MSDN Library DVDs, wielding an update query with no...
February 21, 2009 at 4:00 am
Lynn Pettis (2/20/2009)
Grant Fritchey (2/20/2009)
Lynn Pettis (2/20/2009)
Alvin Ramard (2/20/2009)
He's gone multi-threaded!!!!Is it contagious???
I quit. He's on his own. Total failure.
Uh oh. I think you helped him with your last...
February 21, 2009 at 3:56 am
Lynn Pettis (2/20/2009)
February 20, 2009 at 1:30 pm
Lynn Pettis (2/20/2009)
Alvin Ramard (2/20/2009)
He's gone multi-threaded!!!!Is it contagious???
I quit. He's on his own. Total failure.
February 20, 2009 at 1:27 pm
Lynn Pettis (2/20/2009)
A better comparision, then, would be SELECT myColumn FROM myTable to SELECT DISTINCT myColumn FROM myTable.Be sure to look at the actual execution plans of both of them.
But...
February 20, 2009 at 1:21 pm
Putts (2/20/2009)
The whole point (at...
February 20, 2009 at 1:18 pm
Lynn Pettis (2/20/2009)
Grant Fritchey (2/20/2009)
February 20, 2009 at 1:13 pm
Heck, he's gone full circle and started posting his first message all over again.
February 20, 2009 at 1:11 pm
Viewing 15 posts - 18,226 through 18,240 (of 22,202 total)