Advertisements
Home > Performance Tuning > Dissecting SQL Server Execution Plans

Dissecting SQL Server Execution Plans

I remember my days before, Microsoft SQL Server PFE.  I wanted to learn everything and know everything about SQL Server.  However, getting hold of good resources was tough, as I didn’t have any mentor when I started down my journey to becoming a SQL Server Database Administrator.

Along the way I did pick up lots of books and references.  One of such books is Dissecting SQL Server Execution Plans.

I read this book before becoming PFE, I read this now, and I recommend everyone read this book more then once.

Grant Fritchey (Blog|Twitter) wrote the book back in 2008; I would still recommend take ready.  This book will only help you be better DBA and Developer.

SQL Central, Jeff Moden, Dissecting SQL Server Execution Plans

http://www.sqlservercentral.com/articles/Book+Reviews/69019/

Amazon, SQL Server Execution Plans

http://www.amazon.com/gp/product/1906434026?ie=UTF8&tag=dkranchnet&linkCode=as2&camp=1789&creative=390957&creativeASIN=1906434026

SQL Central, Red Gate, EBook

http://www.sqlservercentral.com/articles/books/65831/?utm_source=ssc&utm_medium=weblink&utm_content=Grant&utm_campaign=sqltoolbelt

This post is cross posted on my SQLCAN Blog, MSDN Blog, and SQL server Consultation blog.

Advertisements
  1. May 31, 2016 at 10:30 am

    Thanks for the kind words. Just so you know, it’s been updated since 2008. There was a second edition in 2012. I’m actively working on another edition now.

  2. June 1, 2016 at 9:21 am

    Cool. Did not know that, just found the 2nd edition link :).

    https://www.amazon.ca/Server-Execution-Plans-Grant-Fritchey-ebook/dp/B00CXWRFQA/ref=sr_1_fkmr0_1?ie=UTF8&qid=1464788951&sr=8-1-fkmr0&keywords=Dissecting+SQL+Server+Execution+Plans

    Will definitely will be reading it next once I am done current book :). Thanks for comment :D.

  3. June 1, 2016 at 9:22 am
  4. June 1, 2016 at 10:00 am

    When you release 3rd edition please let me know, will love to read it :).

  5. Chris Wood
    June 3, 2016 at 9:22 am

    Go on an SQLCruise when he is presenting and he will give you a copy.

  6. Chris Wood
    June 3, 2016 at 1:29 pm

    Also look for Benjamin Nevarez books on the optimizer.

  7. June 3, 2016 at 3:11 pm

    Thank-you will definitely add it to the list to read :).

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: