February 15, 2009 at 9:44 am
Comments posted to this topic are about the item SQL Server 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
September 8, 2009 at 12:10 am
its really great book.
Many Thanks to Author of this book.
Thanks,
Rajesh Varma
April 20, 2010 at 6:29 am
I had no idea this little forum existed.
You're welcome. I'm glad the book was at all useful.
"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
April 4, 2011 at 1:10 am
[font="Verdana"]Grant, if following tiny confusion can be explained?
Do DMV/Fs provide "Actual Execution Plan" or "Estimated Execution plan" specially Sys.DM_exec_Query_Plan?
Logically it should be "Actual Execution Plan" rather than "Estimated Execution plan"! But XML from DMV/Fs does not contain any <RunTimeInformation> tag! 🙂
Thanks!
[/font]
April 4, 2011 at 6:09 am
Abrar Ahmad_ (4/4/2011)
[font="Verdana"]Grant, if following tiny confusion can be explained?Do DMV/Fs provide "Actual Execution Plan" or "Estimated Execution plan" specially Sys.DM_exec_Query_Plan?
Logically it should be "Actual Execution Plan" rather than "Estimated Execution plan"! But XML from DMV/Fs does not contain any <RunTimeInformation> tag! 🙂
Thanks!
[/font]
What you are pulling out of the cache is an estimated plan. The actual plans, with performance metrics based on the parameters passed are not stored.
"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
July 11, 2011 at 1:06 am
Thanks for the book!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 11, 2011 at 5:57 am
Hey grant I've surfed to http://www.scarydba.com/2008/07/02/code-from-dissecting-sql-server-execution-plans/ to download the code of the book and I just can't seem to find the download button.
Care to help a blind man?
July 11, 2011 at 8:46 am
first great book; thanks for the free download.
I've passed this on to my team for recommended reading.
second question: why does the word Kindle in front of Ebook bump the price 10 bucks? 🙂
July 11, 2011 at 8:51 am
CDA (7/11/2011)
second question: why does the word Kindle in front of Ebook bump the price 10 bucks? 🙂
IIRC that book first came out on amazon. Then it was brought in to simple-talk as a free gift.
All in all the 1000s of hors spent writing the book were supposed to bring in some $. So I guess this is why the 10$ for kindle edition.
P.S. The kindle link does not work.
July 11, 2011 at 9:01 am
Thanks for the download, I have been struggling with understanding this topic for a while. I am sure this will help.
July 11, 2011 at 11:44 am
Grant, Thanks for writing this book and thanks to you and red gate for putting online for free in PDF format.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
July 11, 2011 at 5:18 pm
Ninja's_RGR'us (7/11/2011)
Hey grant I've surfed to http://www.scarydba.com/2008/07/02/code-from-dissecting-sql-server-execution-plans/ to download the code of the book and I just can't seem to find the download button.Care to help a blind man?
Not sure. I usually just google for it. It's online somewhere, either here or over at Red Gate.
"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
July 11, 2011 at 5:18 pm
CDA (7/11/2011)
first great book; thanks for the free download.I've passed this on to my team for recommended reading.
second question: why does the word Kindle in front of Ebook bump the price 10 bucks? 🙂
Not a clue. But if you search for it, you can get it as a PDF for free.
"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
July 11, 2011 at 5:19 pm
Trey Staker (7/11/2011)
Grant, Thanks for writing this book and thanks to you and red gate for putting online for free in PDF format.
Thanks. I hope it's helpful.
"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
July 13, 2011 at 9:32 pm
Really nice book. Thanks Grant Fritchey
Thanks
Viewing 15 posts - 1 through 15 (of 21 total)
You must be logged in to reply to this topic. Login to reply