Dissecting SQL Server Execution Plans

  • Jeff Moden

    SSC Guru

    Points: 994667

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

  • Anipaul

    SSC-Insane

    Points: 24681

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

  • alen teplitsky

    SSC-Dedicated

    Points: 30014

    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

    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

    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

    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: 994667

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

  • SQLRNNR

    SSC Guru

    Points: 281210

    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: 994667

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

  • Grant Fritchey

    SSC Guru

    Points: 395510

    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 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Jeff Moden

    SSC Guru

    Points: 994667

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

  • RBarryYoung

    SSC Guru

    Points: 143327

    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: 3503

    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

    Good one...

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

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

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