Dissecting SQL Server Execution Plans

eBook (PDF), 182 Pages
This item has not been rated yet
Price: $17.99
Every day, out in the various discussion boards devoted to Microsoft SQL Server, the same types of questions come up again and again: Why is this query running slow? Is my index getting used? Why does this query run faster than this query? My response is the same n in each case: have you looked at the execution plan? Execution plans provide a wealth of information on how your queries are being executed by SQL Server, and are a vitally important tool for anyone who writes TSQL to access data in a SQL Server database. My goal with this book was to gather as much useful information on execution plans as possible into a single location, and to organize it in such as way that it provided a clear route through the subject. Written and tested for SQL Server 2005, I guide you right from the basics of capturing plans, through their interpretation, and then on to how to use them to understand how you might optimize your SQL queries, improve your indexing strategy, spot some common... More > performance issues, and more. < Less
Available in PDF Format

Ratings & Reviews

Log in to review this item
Lulu Sales Rank: 97522
There are no reviews for the current version of this product
There are no reviews for previous versions of this product

Product Details

First Edition
Simple Talk Publishing
May 15, 2008
File Format
File Size
9.65 MB

Formats for this Ebook

Required Software Any PDF Reader, Apple Preview
Supported Devices Windows PC/PocketPC, Mac OS, Linux OS, Apple iPhone/iPod Touch... (See More)
# of Devices Unlimited
Flowing Text / Pages Pages
Printable? Yes
Report This Content to Lulu >

Moderation of Questionable Content

Thank you for your interest in helping us moderate questionable content on Lulu. If you need assistance with an order or the publishing process, please contact our support team directly.

How does this content violate the Lulu Membership Agreement?


Listed In