Lulu Marketplace

Dissecting SQL Server Execution Plans

By Grant Fritchey
eBook (PDF), 182 Pages
This item has not been rated yet
Dissecting SQL Server Execution Plans
Preview
Price: $17.99
Download immediately.
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 | Product Details | Ebook Formats

Ratings & Reviews

Log in to review this item
There are no reviews for this item
Refreshing...

You Recently Viewed

Product Details

Copyright
Grant Fritchey (Standard Copyright License)
Edition
First Edition
Publisher
Simple Talk Publishing
Published
May 15, 2008
Language
English
Pages
182
File Format
PDF
File Size
9.65 MB

Formats for this Ebook

PDF
Required Software Adobe Digital Editions, Adobe Acrobat, Apple Preview, Stanza
Supported Devices Windows PC/PocketPC, Mac OS, Linux OS, Apple iPhone/iPod Touch... ( See More )
# of Devices Unlimited
Flowing Text / Pages Pages
Learn more about ebook formats and e-readers
Report This Content to Lulu >

Keywords

Listed In

More From Grant Fritchey