Goodreads helps you keep track of books you want to read.
Start by marking “SQL Server Execution Plans” as Want to Read:
SQL Server Execution Plans
Enlarge cover
Rate this book
Clear rating
Open Preview

SQL Server Execution Plans

by
4.5  ·  Rating Details ·  28 Ratings  ·  4 Reviews
Execution plans show you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: Which indexes are being used, and where no indexes are being used at all. How the data is being retrieved, and joined, from the tables defi ned in your query. How aggregations in GROUP ...more
Paperback, 250 pages
Published March 24th 2009 by Simple Talk Publishing (first published March 2008)
More Details... edit details

Friend Reviews

To see what your friends thought of this book, please sign up.

Reader Q&A

To ask other readers questions about SQL Server Execution Plans, please sign up.

Be the first to ask a question about SQL Server Execution Plans

This book is not yet featured on Listopia. Add this book to your favorite list »

Community Reviews

(showing 1-57)
filter  |  sort: default (?)  |  Rating Details
Eric Wisdahl
Jan 16, 2010 Eric Wisdahl rated it it was amazing
Shelves: textbooks, tech-books
This book was an easy read on a subject that can be relatively intimidating for a developer with no experience in the area. It is a great introduction to learning how to read SQL Server Execution Plans. There are lots of good examples and screen shots describing how the server is interpreting the commands being executed.

However, one should note that the book is NOT about how the plans will help you to improve your queries. Instead, knowing how to read through the various execution plans will he
...more
M
Dec 19, 2014 M rated it it was amazing  ·  review of another edition
A clear and concise book on how to read SQL Server Execution Plans and understand the different pieces involved. It has many great examples to illustrate plans generated by T-SQL in the text and shows how they change with various modifications. It's been awhile since I've read a technology book that was this well organized.
Hector Sosa
Hector Sosa rated it it was amazing
Apr 03, 2013
John Deardurff
John Deardurff rated it really liked it
Sep 17, 2015
Kaveh Nowroozi
Kaveh Nowroozi rated it it was amazing
Dec 10, 2015
Delhi Irc
Location: ND6 IRC
Accession No: DL027411
Arun Mahendrakar
Nov 30, 2016 Arun Mahendrakar rated it it was amazing
Yes, that's what this book is about - understanding execution plans. It starts with what happens when you execute a query where the author talks about the parser, algebraizer, the optimizer and the 'executor'!

If you're new to understanding the execution plan concepts, I'd suggest you take the first two chapters slowly and thoroughly. I did this and it helped me to read through the plans myself and I only skimmed over the paragraphs to confirm my knowledge.

This book doesn't tell you how to write
...more
Steven Murawski
Steven Murawski rated it really liked it
Jul 17, 2015
Maxime Daniou
Maxime Daniou rated it it was amazing
Jan 17, 2016
Damian
Damian rated it it was amazing
May 08, 2013
Indra
Indra rated it really liked it
Jul 14, 2012
Nicholas Doyle
Nicholas Doyle rated it really liked it
Jul 06, 2015
Anton Spirin
Anton Spirin rated it it was amazing
Nov 20, 2014
Daniel T
Daniel T rated it really liked it
Jan 18, 2011
Lynne Davidson
Lynne Davidson rated it really liked it
Jul 23, 2015
Tse Man Tik
Tse Man Tik rated it it was amazing
Nov 14, 2015
Lloyd Moore
Lloyd Moore rated it really liked it
Sep 19, 2016
Justin Scott
Justin Scott rated it it was amazing
Mar 29, 2014
stephen lee
stephen lee rated it really liked it
Sep 26, 2015
Ash Chuan
Ash Chuan rated it it was amazing
Jun 12, 2016
Greg Gurevich
Greg Gurevich rated it really liked it
Apr 23, 2013
Alain
Alain rated it it was amazing
Jan 29, 2014
Alexander Fedorenko
Alexander Fedorenko rated it it was amazing
Jun 20, 2012
Elsuket
Elsuket rated it it was amazing
Jul 04, 2014
Todd Everett
Todd Everett rated it really liked it
Oct 16, 2014
Patrick
Patrick rated it really liked it
Nov 06, 2013
Jason
Jason rated it liked it
Feb 13, 2016
Dilyan Dimitrov
Dilyan Dimitrov rated it really liked it
Aug 12, 2014
Yanni Robel
Yanni Robel rated it it was amazing
Jan 01, 2014
Alen
Alen added it
May 27, 2008
Sqldba
Sqldba is currently reading it
Jul 15, 2010
Ben
Ben added it
Aug 31, 2011
John
John added it
Sep 04, 2011
papaya
papaya marked it as to-read
Sep 21, 2011
Anand Sundaram
Anand Sundaram marked it as to-read
Mar 07, 2012
Justin Swenson
Justin Swenson marked it as to-read
Aug 17, 2012
Floyd
Floyd added it
Aug 25, 2012
Dina
Dina marked it as to-read
Nov 01, 2012
Suhas
Suhas marked it as to-read
Nov 19, 2012
Sebastien Charland
Sebastien Charland marked it as to-read
Dec 18, 2012
Jen
Jen marked it as to-read
Mar 27, 2016
Bogdan Sabău
Bogdan Sabău marked it as to-read
Jun 09, 2015
Saravuth Yos
Saravuth Yos marked it as to-read
Apr 10, 2013
Anders Dahlen
Anders Dahlen marked it as to-read
Aug 07, 2013
Jason
Jason added it
Sep 06, 2013
Vatroslav Mileusnić
Vatroslav Mileusnić marked it as to-read
Dec 25, 2013
RG
RG marked it as to-read
Oct 28, 2013
RG
RG marked it as to-read
Nov 01, 2013
Chas
Chas marked it as to-read
Oct 24, 2014
Alain
Alain is currently reading it
Jan 06, 2014
Farhan
Farhan marked it as to-read
Feb 15, 2014
Rav
Rav is currently reading it
Mar 24, 2015
Rafire
Rafire marked it as to-read
Aug 15, 2014
There are no discussion topics on this book yet. Be the first to start one »

Goodreads is hiring!

If you like books and love to build cool products, we may be looking for you.
Learn more »
1417501
I have twenty years experience working in technical support, development and database administration. I currently work for a major insurance company as a DBA. I am a Microsoft SQL MVP. I write articles for publication at SQL Server Central, Simple-Talk, PASS and SQL Server Standard. I have published two books, Dissecting SQL Server Execution Plans and SQL Server 2008 Query Performance Tuning ...more
More about Grant Fritchey...

Share This Book