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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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