Viewing 15 posts - 16,051 through 16,065 (of 22,213 total)
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...
December 11, 2009 at 5:34 am
No, but the use of fonts sure is.
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...
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...
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...
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)...
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...
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...
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,...
December 10, 2009 at 10:11 am
Going blind or something. I can't find the attachments. Where are they?
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...
December 10, 2009 at 7:52 am
Roy Ernest (12/10/2009)
December 10, 2009 at 6:41 am
Jack Corbett (12/10/2009)
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...
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...
December 10, 2009 at 6:37 am
Viewing 15 posts - 16,051 through 16,065 (of 22,213 total)