07 October 2009

SQL Server Execution Plans – eBook Download

Why is my query running slow? Why isn't my index getting used? In order to answer these questions, you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed guide to this essential topic. Download the eBook.

821-ExecutionPlansCover.jpg

Every day, out in the various SQL Server forums, the same types of questions come up again and again: why is this query running slow? Why isn’t my index getting used? And on and on. In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan?”

Grant Fritchey, Author.

SQL Server Execution Plans (link to eBook download – 12MB)

Table of Contents

  • Chapter 01: Execution Plan Basics
  • Chapter 02: Reading Graphical Execution Plans for Basic Queries
  • Chapter 03: Text and XML Execution Plans for Basic Queries
  • Chapter 04: Understanding More Complex Query Plans
  • Chapter 05: Controlling Execution Plans with Hints
  • Chapter 06: Cursor Operations
  • Chapter 07: XML in Execution Plans
  • Chapter 08: Advanced Topics

Book Details

  • Paperback: 250 pages
  • Publisher: Red Gate Books

Keep up to date with Simple-Talk

For more articles like this delivered fortnightly, sign up to the Simple-Talk newsletter

This post has been viewed 5607 times – thanks for reading.

  • Rate
    [Total: 21    Average: 4.5/5]
  • Share

Grant Fritchey

View all articles by Grant Fritchey

Related articles

Also in free ebook

How to Become an Exceptional DBA, 2nd Edition

A 2nd edition of Brad McGehee's popular "career guide" for DBAs, designed to help new and prospective DBAs find their feet in the profession, and to advise those more-experienced on how they can excel at their jobs, and so become Exceptional DBAs...… Read more

Also in Free Stuff

Under the Hood of .NET Memory Management

As well-engineered as the .NET framework is, it's not perfect, and it doesn't always get memory management right. To write truly fantastic software, you need to understand how .NET memory management actually works. This book will take you from the very basics of memory management, all the way to how the OS handles its resources, and will help you write the best code you can.… Read more

Also in Grant Fritchey

SQL Backup Pro for the Accidental DBA

If you've suddenly found yourself responsible for maintaining and backing up your company's servers, you're an 'accidental DBA'. If you've been dropped in the deep end, let Grant Fritchey show you through the backup and restore functionality of Red Gate's SQL Backup Pro, showing you how to schedule regular backups, compress, restore and document your backups with ease.… Read more

Also in Performance

T-SQL Window Function Speed Phreakery: The FIFO Stock Inventory Problem

Sometimes, in the quest for raw SQL performance, you are forced to sacrifice legibility and maintainability of your code, unless you then document your code lavishly. Phil Factor's SQL Speed Phreak challenge produced some memorable code, but can SQL features introduced since then help to produce code that performs as well and is also easy to understand? Aunty Kathi investigates.… Read more
  • mcflyamorim

    Thanks
    Hello Grant,

    Congrats and thanks a lot to share.

  • Banutharan

    Hi…Its about SQL Server Execution Plans PDF book
    Hi,

    Today I downloaded pdf document. Since very long back I am exploring stuff like this, luckily I got it and it’s awesome and clearly explained everything about Execution Plan, very good stuff too.

    Thanks,
    Ramesh.

  • jayachandra

    Thank you for uploading SQL Server Execution Plans PDF book
    Thank you for uploading SQL Server Execution Plans PDF book.this is very help full book.

  • ilovedotnet

    Thanks
    Thank you for sharing this book!

  • dharshan

    Very Helpful
    Thanks for uploading the PDF document, It is very helpful

  • evalenca

    Source code
    Hi!!!!

    This bok is very helpful.
    But i can’t find the source codes from this website.
    Could you help me.

    Thank you

    Eduardo

  • gitmo

    Source Code
    I cannot find the source code on Simple-Talk.

  • amit.blue

    Appreciate
    Hi Grant,

    Its a pleasure to read the book that is so well planned and well written. This is really the first time I have come across such a stuff on Execution plans.

    Hats off for the work you have done….

    Really appreciate that.

  • ahmad_hassan1511

    Thanks
    Thank You
    For This Book

  • eliassal

    2008 and code samples
    Very interesting book. Are all items applicable to sql 2008 R2 as well or there are some changes.
    Can you please provide us the link to download the code samples, I am not able to find it on the site, thanks in advance.

  • shrikant948

    Thanks
    Hi

    Thanks for this book.

  • Grant Fritchey

    RE: 2008
    It is mostly applicable to 2008. However, we’re actively rewriting the book to make it more up to date.

  • Kalimuthu

    Thanks
    Thanks lot.

  • TTao675

    Thank you for the sharing.
    good book

  • vikrant.a.more

    Thank you so much..
    Thank You so much for the sharing a valuable notes regarding Execution plan.

  • Peter

    Excellent book
    Fantastic book has inspired me to do some SQL optimisation training with our dev teams. A really good read which clearly answered most of my questions. The only thing that I felt was missing was a good theoretical and practical section on how to decide what columns to index and in what order; something like this: http://sqlserverpedia.com/wiki/Index_Selectivity_and_Column_Order

    Thanks again,
    Peter

  • raajkul

    Execllent Book
    Thanks a lot for making this topic available on internet. This is really great stuff.

  • maximiliano.morales

    Copy / Paste para traduccion
    Estimado: es posible me pueda compartir una versión con la opción para copiar y pegar activa del libro ebook-dissectingsqlserverexecutionplans, lo necesito para ir traduciendo el libro ya que mi ingles no es tan preciso como quisiera.

  • lesnic

    About the rewrite…
    Is the update/rewrite of the book available?

  • MAC1867

    Execution Plans
    Don’t seem to be able to locate the example code for the title
    ‘Dissecting SQL Server Execution Plans’
    Thanks

Join Simple Talk

Join over 200,000 Microsoft professionals, and get full, free access to technical articles, our twice-monthly Simple Talk newsletter, and free SQL tools.

Sign up