Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

SQL Server Execution Plans Expand / Collapse
Author
Message
Posted Sunday, February 15, 2009 9:44 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 15,737, Visits: 28,143
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #657342
Posted Tuesday, September 8, 2009 12:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 7:10 AM
Points: 1, Visits: 82
its really great book.
Many Thanks to Author of this book.

Thanks,
Rajesh Varma
Post #784005
Posted Tuesday, April 20, 2010 6:29 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 15,737, Visits: 28,143
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #906762
Posted Monday, April 4, 2011 1:10 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 11:12 AM
Points: 212, Visits: 1,116
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!

Post #1087919
Posted Monday, April 4, 2011 6:09 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 15,737, Visits: 28,143
Abrar Ahmad_ (4/4/2011)
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!



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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1087994
Posted Monday, July 11, 2011 1:06 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:49 AM
Points: 13,735, Visits: 10,703
Thanks for the book!



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1139543
Posted Monday, July 11, 2011 5:57 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:44 AM
Points: 21,405, Visits: 9,617
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?
Post #1139678
Posted Monday, July 11, 2011 8:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:30 PM
Points: 128, Visits: 448
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? :)



Post #1139796
Posted Monday, July 11, 2011 8:51 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:44 AM
Points: 21,405, Visits: 9,617
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.
Post #1139801
Posted Monday, July 11, 2011 9:01 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 7:35 AM
Points: 2,819, Visits: 2,563
Thanks for the download, I have been struggling with understanding this topic for a while. I am sure this will help.
Post #1139814
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse