November 10, 2009 at 9:26 am
Perhaps his MVP tag, superior knowledge and experience would help you change your mind...?
If you knew his real name and background, you might be keener to learn from him.
I can only hope that your attitude matures over time.
Good luck, sincerely.
Funny!...
I treat all people equally. What ever you have on your signature, does not dictates what you know or what you are ... and will not make you better or superior than anyone.
By the way, you would be surprise of who I am and my experience.
Yep, wish your attitude change as well, it should...
Good luck too ...
November 10, 2009 at 2:31 pm
There's no pleasing some people!
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
November 10, 2009 at 3:32 pm
|--| (11/9/2009)
Everything inside MS-SQL cache, should and must be actual execution plans or not? if s there, means it ran or it is running now.
Estimated and actual are, in my opinion, misleading terms and lead to exactly this misunderstanding. An 'actual' execution plan is, at least in the sense we're asking, one that has the run-time information in it. Actual row counts, actual execution counts, that kind of thing. Only way to get these is to run the query in management studio with the 'include actual execution plan' option or to run the query and capture the plan with profiler. (showplan xml)
The plan retrieved from cache does not have the run-time information in it and hence is pretty much the same as an estimated exec plan, especially since what we need to see to tell if this really is parameter sniffing or a bad stats problem, is the difference between estimated number of rows and actual number of rows. The latter will not be in a plan retrieved from the plan cache.
I thought I'd mentioned this in a post I made in this thread last week. My bad.
Or ... did someone change how MS-SQL works this year?:cool:
Nope. In this regard hasn't changed since 2005.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 10, 2009 at 3:37 pm
|--| (11/10/2009)
By the way, you would be surprise of who I am and my experience.
Do tell.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 31 through 33 (of 33 total)
You must be logged in to reply to this topic. Login to reply