Viewing 15 posts - 16,066 through 16,080 (of 22,226 total)
Lynn Pettis (12/10/2009)
Roy Ernest (12/10/2009)
I dont fall under that category..I know nothing.... I know nothing... :w00t:
Dating myself here, but I actually hear Sgt Shultz from Hogan's Heros! :w00t:
Me too. 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
December 10, 2009 at 12:43 pm
Roy Ernest (12/10/2009)
Lynn Pettis (12/10/2009)
Alvin Ramard (12/10/2009)
GSquared (12/10/2009)
Roy Ernest (12/10/2009)
To be honest, There are lots of Indians here who give other Indians a bad name... 🙁
And plenty of Americans who...
"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
December 10, 2009 at 12:43 pm
GilaMonster (12/10/2009)
jcrawf02 (12/10/2009)
Gail's being subtle again - I'd be SOM if I were drinking anything :hehe:I'm losing my temper with him. And that takes some doing these days.
It doesn't look...
"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
December 10, 2009 at 12:12 pm
Lowell (12/10/2009)
if the index for date_entered was in place, would we expect an INDEX SEEK and an estimated 10 rows(because of the TOP 10)...
"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
December 10, 2009 at 11:26 am
Jack Corbett (12/10/2009)
CirquedeSQLeil (12/10/2009)
I think Jack should go visit Grant for a week - see how he fares.
Grant lives in Southern New England, it doesn't even really get cold there...
"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
December 10, 2009 at 10:16 am
Lowell (12/10/2009)
it looks to me like this is the costliest item: a table SCAN of almost 500,000 rows, which then...
"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
December 10, 2009 at 10:13 am
Right. The estimated execution plans are identical. That means the same query should be run for both processes. However, to be really sure, you'd need to see actual execution plans,...
"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
December 10, 2009 at 10:11 am
Going blind or something. I can't find the attachments. Where are they?
"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
December 10, 2009 at 9:25 am
Just so you know, you can save the graphical plan as a .sqlplan file and attach that file to the posts. It makes the whole process for all of us...
"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
December 10, 2009 at 7:52 am
Roy Ernest (12/10/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
December 10, 2009 at 6:41 am
Jack Corbett (12/10/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
December 10, 2009 at 6:40 am
GilaMonster (12/10/2009)
Grant Fritchey (12/10/2009)
Jack Corbett (12/9/2009)
OPASS stands for Orlando PASS and, yes, that would be Florida with Disney and all that. It was 80's today and we have the...
"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
December 10, 2009 at 6:39 am
sqllearner-339367 (12/10/2009)
I have tried executing stored procedure and dynamic query under the same ansi setting. Execution time is 1min:05 seconds for stored procedure and 30 seconds for dynamic query.
Im...
"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
December 10, 2009 at 6:37 am
Jack Corbett (12/9/2009)
OPASS stands for Orlando PASS and, yes, that would be Florida with Disney and all that. It was 80's today and we have the AC on now,...
"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
December 10, 2009 at 5:23 am
Jeff Moden (12/9/2009)
Grant Fritchey (12/9/2009)
I always forget this one. How do you flip the "run faster" switch to the on position in SQL Server?
BWAA-HAAA!!! Whenever I get a "make...
"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
December 10, 2009 at 5:21 am
Viewing 15 posts - 16,066 through 16,080 (of 22,226 total)