Dissecting 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 Jeff Moden » Dissecting SQL Server Execution Plans

14 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

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:30 PM
Points: 32,893, Visits: 26,770

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 on T-SQL questions, 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

Anipaul

Posted Thursday, December 17, 2009 5:06 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:50 AM
Points: 4,785, Visits: 1,334

After going thru your review, I will try to grab the book for my collection. Great...

Post #835595

alen teplitsky

Posted Thursday, December 17, 2009 6:58 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:05 PM
Points: 1,408, Visits: 4,505

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

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]

Post #835636

TravisDBA

Posted Thursday, December 17, 2009 8:34 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:23 AM
Points: 1,288, Visits: 2,996

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.

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ... BigGrin

Post #835719

JeremyG

Posted Thursday, December 17, 2009 9:12 AM

SSC Rookie

Group: General Forum Members
Last Login: Sunday, December 11, 2011 10:58 AM
Points: 49, Visits: 100

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

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, April 25, 2013 6:28 AM
Points: 534, Visits: 593

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.

"Beliefs" get in the way of learning.

Post #835858

Jeff Moden

Posted Thursday, December 17, 2009 7:51 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:30 PM
Points: 32,893, Visits: 26,770

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

SQLRNNR

Posted Friday, December 18, 2009 9:54 AM

SSCoach

Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:46 PM
Points: 18,732, Visits: 12,329

Nice review, thanks for the info Jeff.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

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

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:30 PM
Points: 32,893, Visits: 26,770

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

SSChampion

Group: General Forum Members
Last Login: Today @ 12:19 PM
Points: 13,371, Visits: 25,144

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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #836868

« Prev Topic | Next Topic »

14 posts, Page 1 of 2

1 2 »»

Permissions