Dissecting SQL Server Execution Plans

SQLServerCentral is supported by Red Gate Software Ltd.

Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Jeff Moden » Dissecting SQL Server Execution Plans

13 posts, Page 1 of 2

1 2 »»

Dissecting SQL Server Execution Plans

Rate Topic

Display Mode

Topic Options

Author

Message

Jeff Moden

Posted Thursday, December 17, 2009 12:05 AM

SSChampion

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

Anirban Paul

Posted Thursday, December 17, 2009 5:06 AM

Hall 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

SQL Noob

Posted Thursday, December 17, 2009 6:58 AM

Ten 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

TravisDBA

Posted Thursday, December 17, 2009 8:34 AM

SSC-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

JeremyG

Posted Thursday, December 17, 2009 9:12 AM

SSC 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

Robert Frasca

Posted Thursday, December 17, 2009 11:19 AM

Old 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

Jeff Moden

Posted Thursday, December 17, 2009 7:51 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 8:41 AM
Points: 20,041, Visits: 13,610

Robert Frasca (12/17/2009)

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

Post #836097

CirquedeSQLeil

Posted Friday, December 18, 2009 9:54 AM

SSCertifiable

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

Jeff Moden

Posted Friday, December 18, 2009 11:16 AM

SSChampion

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

Post #836523

Grant Fritchey

Posted Sunday, December 20, 2009 4:45 AM

SSCertifiable

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 »

13 posts, Page 1 of 2

1 2 »»

Permissions