SQLServerCentral / Discuss Content Posted by Grant Fritchey / Article Discussions / Article Discussions by Author / SQL Server Execution Plans / Latest Posts

RE: SQL Server Execution Plans

Grant Fritchey — Tue, 15 Nov 2011 05:58:37 GMT

Sounds like you guys covered it all better than I would have. Thanks!

RE: SQL Server Execution Plans

Ninja's_RGR'us — Mon, 14 Nov 2011 04:33:43 GMT

[quote][b]GilaMonster (11/14/2011)[/b][hr]This: [url]http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/[/url][/quote]And make sure to read this excellent comment at the end![url]http://www.sqlskills.com/BLOGS/KIMBERLY/post/The-Tipping-Point-Query-Answers.aspx[/url]:hehe:

RE: SQL Server Execution Plans

GilaMonster — Mon, 14 Nov 2011 04:27:11 GMT

This: [url]http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/[/url]

RE: SQL Server Execution Plans

Ninja's_RGR'us — Mon, 14 Nov 2011 04:21:29 GMT

Sab must return less rows. An index seek + bookmark lookup is a very costly operation. It takes very little data returned to make a table scan more efficient than a seek + lookup.

RE: SQL Server Execution Plans

s.pig.snow — Mon, 14 Nov 2011 02:33:23 GMT

Grant, I confused for a question when I'm reading <Dissecting SQL ServerExecution Plans>:Following two T-SQL generate two different plans, but I don't know why:--Clustered index scanSELECT ContactID,LastName,EmailAddress FROM person.Contact WHERE EmailAddress LIKE 'sa%'--NonClustered index seek and Key LookupSELECT ContactID,LastName,EmailAddress FROM person.Contact WHERE EmailAddress LIKE 'sab%'Would you give me some suggestion please?Thanks a lot.s.pig.snow@gmail.com

RE: SQL Server Execution Plans

Ninja's_RGR'us — Fri, 11 Nov 2011 06:42:07 GMT

[quote][b]Laurence Neville (11/11/2011)[/b][hr]Hi Grant,One question about the book:You refer a couple of times to indexed views that "only refresh once per day". My understanding was that indexed views are updated instantly when base table data is updated, and I can only find references to Oracle materialised views having this "refresh" function. Is there something I am missing?Thanks[/quote]It's probably something like a temp reporting table loaded from a view.Your understanding of the indexed views is correct.

RE: SQL Server Execution Plans

Laurence Neville — Fri, 11 Nov 2011 06:35:47 GMT

Hi Grant,One question about the book:You refer a couple of times to indexed views that "only refresh once per day". My understanding was that indexed views are updated instantly when base table data is updated, and I can only find references to Oracle materialised views having this "refresh" function. Is there something I am missing?Thanks

RE: SQL Server Execution Plans

Hardy21 — Wed, 13 Jul 2011 21:32:02 GMT

Really nice book. Thanks Grant Fritchey

RE: SQL Server Execution Plans

Grant Fritchey — Mon, 11 Jul 2011 17:19:37 GMT

[quote][b]Trey Staker (7/11/2011)[/b][hr]Grant, Thanks for writing this book and thanks to you and red gate for putting online for free in PDF format.[/quote]Thanks. I hope it's helpful.

RE: SQL Server Execution Plans

Grant Fritchey — Mon, 11 Jul 2011 17:18:57 GMT

[quote][b]CDA (7/11/2011)[/b][hr]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? :)[/quote]Not a clue. But if you search for it, you can get it as a PDF for free.

RE: SQL Server Execution Plans

Grant Fritchey — Mon, 11 Jul 2011 17:18:23 GMT

[quote][b]Ninja's_RGR'us (7/11/2011)[/b][hr]Hey grant I've surfed to [url]http://www.scarydba.com/2008/07/02/code-from-dissecting-sql-server-execution-plans/[/url] to download the code of the book and I just can't seem to find the download button.Care to help a blind man?[/quote]Not sure. I usually just google for it. It's online somewhere, either here or over at Red Gate.

RE: SQL Server Execution Plans

Trey Staker — Mon, 11 Jul 2011 11:44:03 GMT

Grant, Thanks for writing this book and thanks to you and red gate for putting online for free in PDF format.

RE: SQL Server Execution Plans

Daniel Bowlin — Mon, 11 Jul 2011 09:01:47 GMT

Thanks for the download, I have been struggling with understanding this topic for a while. I am sure this will help.

RE: SQL Server Execution Plans

Ninja's_RGR'us — Mon, 11 Jul 2011 08:51:30 GMT

[quote][b]CDA (7/11/2011)[/b][hr]second question: why does the word Kindle in front of Ebook bump the price 10 bucks? :)[/quote]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.

RE: SQL Server Execution Plans

CDA — Mon, 11 Jul 2011 08:46:49 GMT

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? :)

RE: SQL Server Execution Plans

Ninja's_RGR'us — Mon, 11 Jul 2011 05:57:13 GMT

Hey grant I've surfed to [url]http://www.scarydba.com/2008/07/02/code-from-dissecting-sql-server-execution-plans/[/url] to download the code of the book and I just can't seem to find the download button.Care to help a blind man?

RE: SQL Server Execution Plans

Koen Verbeeck — Mon, 11 Jul 2011 01:06:44 GMT

Thanks for the book!

RE: SQL Server Execution Plans

Grant Fritchey — Mon, 04 Apr 2011 06:09:16 GMT

[quote][b]Abrar Ahmad_ (4/4/2011)[/b][hr][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][/quote]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.

RE: SQL Server Execution Plans

Abrar Ahmad_ — Mon, 04 Apr 2011 01:10:15 GMT

[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]

RE: SQL Server Execution Plans

Grant Fritchey — Tue, 20 Apr 2010 06:29:31 GMT

I had no idea this little forum existed.You're welcome. I'm glad the book was at all useful.

RE: SQL Server Execution Plans

rajesh_r_Varma — Tue, 08 Sep 2009 00:10:56 GMT

its really great book.Many Thanks to Author of this book.Thanks,Rajesh Varma

SQL Server Execution Plans

Grant Fritchey — Sun, 15 Feb 2009 09:44:16 GMT

Comments posted to this topic are about the item [B]SQL Server Execution Plans[/B]