SQL Server Execution Plans

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Grant Fritchey » SQL Server Execution Plans

22 posts, Page 2 of 3

««1 2 3 »»

SQL Server Execution Plans

Rate Topic

Display Mode

Topic Options

Author

Message

Trey Staker

Posted Monday, July 11, 2011 11:44 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 4:52 PM
Points: 1,379, Visits: 2,626

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

Post #1139930

Grant Fritchey

Posted Monday, July 11, 2011 5:18 PM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:20 PM
Points: 13,371, Visits: 25,142

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
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 #1140078

Grant Fritchey

Posted Monday, July 11, 2011 5:18 PM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:20 PM
Points: 13,371, Visits: 25,142

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
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 #1140079

Grant Fritchey

Posted Monday, July 11, 2011 5:19 PM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:20 PM
Points: 13,371, Visits: 25,142

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
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 #1140080

Hardy21

Posted Wednesday, July 13, 2011 9:32 PM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:42 PM
Points: 877, Visits: 1,158

Really nice book. Thanks Grant Fritchey

Thanks

Post #1141464

Laurence Neville

Posted Friday, November 11, 2011 6:35 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, March 22, 2013 3:32 PM
Points: 14, Visits: 87

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

Post #1204073

Ninja's_RGR'us

Posted Friday, November 11, 2011 6:42 AM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 5:19 AM
Points: 21,357, Visits: 9,530

Laurence Neville (11/11/2011)

It's probably something like a temp reporting table loaded from a view.

Your understanding of the indexed views is correct.

Post #1204086

s.pig.snow

Posted Monday, November 14, 2011 2:33 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, November 15, 2011 6:30 AM
Points: 1, Visits: 4

Grant, I confused for a question when I'm reading <Dissecting SQL Server
Execution Plans>:

Following two T-SQL generate two different plans, but I don't know why:

--Clustered index scan
SELECT ContactID,LastName,EmailAddress FROM person.Contact WHERE EmailAddress LIKE 'sa%'
--NonClustered index seek and Key Lookup
SELECT 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

Post #1204963

Ninja's_RGR'us

Posted Monday, November 14, 2011 4:21 AM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 5:19 AM
Points: 21,357, Visits: 9,530

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.

Post #1205026

GilaMonster

Posted Monday, November 14, 2011 4:27 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 2:45 PM
Points: 37,635, Visits: 29,885

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

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1205029

« Prev Topic | Next Topic »

22 posts, Page 2 of 3

««1 2 3 »»

Permissions