<p>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 BY queries are put together. • The anticipated load and the estimated cost that all these operations place upon the system. Grant Fritchey's book is the only in-depth look at how to improve your SQL query performance through careful design of execution plans. Sample chapters of the ebook have garnered stunning reviews, such as: "All I can say is WOW. This has to be the best reference I have ever seen on Execution Plans in SQL Server. My hats off to Grant Fritchey" Jonathan Kehayias.</p>

SQL Server Execution Plans

Computers & Technology

Fritchey, Grant

Programming Languages

Simple Talk Publishing

The Best of SQLservercentral.com: v. 6 [Oct 01, 2008] Jones, Steve

The Best of SQLservercentral.com (v. 6)

Steve, Jones

<p>SQL Server Profiler is one of the most useful of SQL Server's "built-in" tools, recording data about various SQL Server events. "Mastering SQL Server Profiler" will make it easier for you to learn how to use Profiler, analyze the data it provides, and to take full advantage of its potential for troubleshooting SQL Server problems. All the examples have been optimized to work with both SQL Server 2005 and 2008.</p>

Mastering SQL Server Profiler

McGehee MCSE MCT MCP, Brad

Databases & Big Data

See the best price to sell, buy or rent books by the Simple Talk Publishing publisher. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Simple Talk Publishing