Dig into the internals of tuning and optimization features in SQL Server 2005—with insights from leading SQL Server experts. This in-depth guide delivers best practices, pragmatic advice, and code samples to help you enable efficient, effective queries—and optimize database performance. Discover how to: Create a baseline and monitor workload by using System Monitor and DMVs Design, manipulate, and manage traces to isolate database performance issues Audit user activity by using built-in default, black box, and Common Criteria traces Analyze query execution using scans and seeks, joins, aggregations, unions, and parallelism Generate efficient and cost-effective queries using cached plans or new plans Detect and resolve locking, blocking, and deadlocking concurrency issues Use best practices to diagnose and troubleshoot response time, throughput, and scalability issues PLUS—Includes Transact-SQL code samples and on the Web

Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization

Computers & Technology

Adam Machanic

Kalen Delaney

Sunil Agarwal

Craig Freedman

Ron Talmage

Networking & Cloud Computing

Microsoft Press

Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential. Discover how SQL Server works behind the scenes, including: 
<ul>
<li>What happens internally when SQL Server builds, expands, shrinks, and moves databases</li> <li>How to use event tracking—from triggers to the Extended Events Engine</li> <li>Why the right indexes can drastically reduce your query execution time</li> <li>How to transcend normal row-size limits with new storage capabilities</li> <li>How the Query Optimizer operates</li> <li>Multiple techniques for troubleshooting problematic query plans</li> <li>When to force SQL Server to reuse a cached query plan—or create a new one</li> <li>What SQL Server checks internally when running DBCC</li> <li>How to choose among five isolation levels and two concurrency models when working with multiple concurrent users</li> </ul>

Microsoft® SQL Server® 2008 Internals (Pro - Developer)

Conor Cunningham

Paul S. Randal

Benjamin Nevarez

Kimberly L. Tripp

Programming

* First book to provide comprehensive, deeply practical coverage on all major new SS2005 features. • Lead author (Tom Rizzo) is a key member of the SQL Server team at Microsoft and a respected author and blogger. • Gets the DBA and developer up and running with SS2005 in the fastest possible time. • The facts, not the evangelism.

Pro SQL Server 2005

Thomas Rizzo

Robin Dewson

Rob Walters

Joseph Sack

Julian Skinner

Louis Davidson

Apress

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

Books by Adam Machanic