Viewing 15 posts - 18,256 through 18,270 (of 22,226 total)
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
Lynn Pettis (2/20/2009)
Grant Fritchey (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:13 pm
Heck, he's gone full circle and started posting his first message all over again.
"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:11 pm
But that example compares one thing you shouldn't do, SELECT *, with another thing that has serious enough costs that it almost needs to be in the shouldn't do category,...
"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:08 pm
Putts (2/20/2009)
Are there certain cases where...
"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:05 pm
josephptran2002 (2/20/2009)
I have 4 tables such as BOCLEARED, CTCLEARED, NHCLEARED, and TOTALCLEARED.
In table BOCLEARED (given), it includes 3 columns such as
DDS BOCLEARED...
"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 12:50 pm
Add a hearty "me too" to everything Steve said.
This was just posted on Brad Magehee's blog today:
http://technet.microsoft.com/en-us/library/cc917672.aspx
"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 12:34 pm
From the sounds of things, not everything is in the same database. I'm not sure that's a mistake or by design. In general, if you're getting an error that says...
"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 12:23 pm
Putts (2/20/2009)
My view, with no WHERE clause, will return millions of records. With the WHERE clause being used it's narrowed down...
"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 12:20 pm
Viewing 15 posts - 18,256 through 18,270 (of 22,226 total)