Viewing 15 posts - 16,051 through 16,065 (of 22,219 total)
RBarryYoung (12/12/2009)
Oops!
Congrats Barry.
I can't decide if "oops" is incredibly sad or absolutely appropriate for the 10,000th post.
"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 13, 2009 at 6:40 am
GabyYYZ (12/11/2009)
Lynn Pettis (12/11/2009)
GabyYYZ (12/11/2009)
Lynn Pettis (12/11/2009)
Sometimes, you just have to question people.
Was the original post a request or a command? (or is it a followup to another thread...
"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 11, 2009 at 1:35 pm
Nah, none of this honor stuff. 10,000 should be a total scramble. Biting, kicking, scratching. In honor of the 10,000.
"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 11, 2009 at 12:41 pm
sqllearner-339367 (12/11/2009)
Grant,Actual estimated plan attached. (Wake up call to update my skills)
Ta
Looking at the plan, you're still getting scans. Is this taken after you added the index that improved performance...
"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 11, 2009 at 6:37 am
sqllearner-339367 (12/11/2009)
Grant,Actual estimated plan attached. (Wake up call to update my skills)
Ta
Actual "estimated" plan.... Is that like honest politician? Kidding.
Plans are either "estimated" meaning they're the plan generated by 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 11, 2009 at 6:29 am
I have yet to find a need for writing a CLR package of any kind, so I'm not using CLR directly.
However, I do use CLR quite a lot. We have...
"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 11, 2009 at 5:51 am
sqllearner-339367 (12/11/2009)
Hi Grant,Neither Ctrl + M or clicking Include Actual Execution plan is not bringing the execution plan.
Not suer why this is happening.
Ta
You have to then execute the query. It...
"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 11, 2009 at 5:34 am
No, but the use of fonts sure is.
"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 1:15 pm
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
Viewing 15 posts - 16,051 through 16,065 (of 22,219 total)