Viewing 15 posts - 18,241 through 18,255 (of 22,219 total)
GilaMonster (2/23/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 23, 2009 at 11:43 am
If the Thread is Skynet, I'm a lot more afraid of this than I am some silly anthropomorphic robot
http://en.wikipedia.org/wiki/RQ-4_Global_Hawk
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 23, 2009 at 9:34 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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'
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 23, 2009 at 6:24 am
Kit G (2/21/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2009 at 7:31 am
Credit where it's due.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2009 at 4:36 am
And now I've spammed the endless thread.
Sorry everyone, sorry, I just got carried away.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2009 at 3:56 am
Lynn Pettis (2/20/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 20, 2009 at 1:21 pm
Putts (2/20/2009)
The whole point (at...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 20, 2009 at 1:18 pm
Viewing 15 posts - 18,241 through 18,255 (of 22,219 total)