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


12»»

Dissecting SQL Server Execution Plans Expand / Collapse
Author
Message
Posted Thursday, December 17, 2009 12:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:41 AM
Points: 20,041, Visits: 13,610
Comments posted to this topic are about the item Dissecting SQL Server Execution Plans

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #835574
Posted Thursday, December 17, 2009 5:06 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, February 11, 2010 7:52 AM
Points: 3,450, Visits: 976
After going thru your review, I will try to grab the book for my collection. Great...


Post #835595
Posted Thursday, December 17, 2009 6:58 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:03 PM
Points: 1,014, Visits: 3,753
downloaded it again, thank you

check into selling it in the iTunes App Store. I recently found a lot of SQL books there for a lot less than the Amazon price.

i bought this one

[url=http://www.amazon.com/Inside-Microsoft%C2%AE-SQL-Server%C2%AE-2008/dp/0735626030/ref=sr_1_1?ie=UTF8&s=books&qid=1261058271&sr=8-1][/url]

for $5.99 and read it on the train to and from work everyday
Post #835636
Posted Thursday, December 17, 2009 8:34 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Yesterday @ 1:48 PM
Points: 177, Visits: 342
Not only is the book great, but all of his videos on the subject on http://www.sqlshare.com are also must sees as well. He is one of the best speakers on the site bar none BTW, you can download the e-book PDF version for free too. :) Travis.
Post #835719
Posted Thursday, December 17, 2009 9:12 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 03, 2010 2:46 PM
Points: 49, Visits: 88
Just downloaded the ebook now from sqlservercentral...I always try to learn something new every day, sounds like this will help me do just that. Thanks for the tip.
Post #835756
Posted Thursday, December 17, 2009 11:19 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 12:10 PM
Points: 375, Visits: 298
I have the book on my desk. I also have had the pleasure of speaking with Grant and hearing him speak at the New England SQL Server User Group and a SQL Code Camp. He also has anothe book out which is equally good. SQL Server 2008 Query Performance Tuning Distilled.

Nice review and you really did a great job of identifying the value of the book.
Post #835858
Posted Thursday, December 17, 2009 7:51 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:41 AM
Points: 20,041, Visits: 13,610
Robert Frasca (12/17/2009)
I have the book on my desk. I also have had the pleasure of speaking with Grant and hearing him speak at the New England SQL Server User Group and a SQL Code Camp. He also has anothe book out which is equally good. SQL Server 2008 Query Performance Tuning Distilled.

Nice review and you really did a great job of identifying the value of the book.


I've read that one cover to cover, as well. As you say, it's equally as good.

Thanks for your comment on the review, Robert.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #836097
Posted Friday, December 18, 2009 9:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:23 AM
Points: 5,633, Visits: 2,267
Nice review, thanks for the info Jeff.



Jason
I have given a name to my pain...

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #836446
Posted Friday, December 18, 2009 11:16 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:41 AM
Points: 20,041, Visits: 13,610
CirquedeSQLeil (12/18/2009)
Nice review, thanks for the info Jeff.


You bet, Jason. Thanks for the feedback. Grant is an easy read... I read his book in just two nights. Heh... if you want a primer in XML, that's in there, too!


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #836523
Posted Sunday, December 20, 2009 4:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:49 AM
Points: 7,338, Visits: 15,101
Hey Jeff,

Thanks for the great review and the kind words. "I'm not worthy" doesn't begin to cover it, but thanks for the sentiments.


----------------------------------------------------
"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 2008 Query Performance Tuning Distilled

For better & quicker help read:
How to Post Performance Problems
Post #836868
« Prev Topic | Next Topic »

12»»

Permissions Expand / Collapse