Dissecting SQL Server Execution Plans

Question

Post reply

Dissecting SQL Server Execution Plans

Jeff Moden

SSC Guru

Points: 1004323
More actions
December 17, 2009 at 12:05 am

#228612

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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Anipaul SSC-Insane Points: 24681 More actions · Answer 1

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

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 2

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

for $5.99 and read it on the train to and from work everyday

TravisDBA SSCoach Points: 15780 More actions · Answer 3

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. ...:-D"

JeremyG SSC Enthusiast Points: 193 More actions · Answer 4

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.

Robert Frasca SSCertifiable Points: 6026 More actions · Answer 5

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.

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 6

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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Nice review, thanks for the info Jeff.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 8

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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 9

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

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 10

Grant Fritchey (12/20/2009)
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.

Heh... Humility and knowledge will get you everywhere, Grant. Both books were an absolute pleasure to read and study. "Not worthy" certainly isn't a phrase that ever entered my mind while I was reading them. I've used the new knowledge I've found in those books many times since I've read them and that's the true worth of a good book. Very well done, Grant.

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

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

RBarryYoung SSC Guru Points: 143329 More actions · Answer 11

Great review, Jeff and I totally agree. An excellent book by a great writer, SQL expert, supportive resource, and all-around excellent guy. 🙂

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

jswong05 Hall of Fame Points: 3553 More actions · Answer 12

Excellent book. I actually used it for over a year to solve many performance problems on our prodution databases. I have actually gone beyond the book's level to solve prodution issues. Let me explain: the book is excellent, it gives some simple examples of query so one can understand the underneath wiring. However in production performance tuning scenarios, I have most of times more complex situations that I have to think outside the box and utilize author's concept to solve real-world problems. It is an excellent reference book to prove to your boss what was wrong in the system.

This is a must read. BTW, another "must read" book is Tom Kyte "Expert Oracle ....". He wrote for Oracle, but the TP explanation (isolation, locking ....) is excellent (if anyone have questions or doubts how database processes records, you must read this book).

Jason
http://dbace.us
😛

Sakthivel Chidambaram SSCertifiable Points: 5531 More actions · Answer 13

Good one...

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc