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

By Kalen Delaney, Adam Machanic, Sunil Agarwal, et al.

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 This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0735621969
• ISBN13: 9780735621961
• Release Date: September 2007
• Publisher: Microsoft Press
• Length: 436 Pages
• Weight: 1.85 lbs.
• Dimensions: 9.0" x 1.0" x 7.4"

Customer Reviews

Review of Inside Microsoft SQL Server 2005 Query Tuning and Optimization

SQL performance tuning is probably one of those things you can do to really make a HUGE difference in performance. Let's put this in perspective: take a typical application, if you can improve the performance by 100% then you really made a huge improvement. You can improve a SQL query by 1000% with 2 lines of code (sometimes all you have to do is take away a % sign). If you can make a query sargable so that the optimizer can...

A must-have for tuning SQL Queries

I rarely review books, but for this one I feel compelled to do so. I knew that SQL Queries were creating major bottlenecks in my web application, but I did not know which ones they were and how to fix them. My app was already live with thousands of users, and since I am primarily a web developer (and not a database expert), I needed practical help, and fast. Because of this book, within a matter of days I went from clueless...

A must for serious SQL 2005 specialists

I have read around 25 SQL 7/2000/2005 books including all 3 books and 1 pamphlet from Kalen Delaney. This is by far the best Kalen Delaney book and one of the best SQL 2005 books. Unlike her other SQL 2005 book (SQL 2005 Storage Engine), this book does not suffer from convoluted and often incomprehensible writing. This book covers (and covers it well): 1)Performance tuning using different indexes. 2)SQL execution plans...

Kudos to Kalen & Company for the Definitive SQL 2005 PTO Manual

I received a copy of this latest- & -greatest book on SQL Server 2005 performance tuning & optimization--my passion & my career-- & am frankly in awe. Being a long-time fan, admittedly I was favorably predisposed. Yet I am frankly amazed at the extent to which in my initial review my expectations have been exceeded. The work of Kalen et al is likely to serve as not merely a guidebook but a milestone, providing a step-by-step...

Kalen's Magnum opus

At first glance, Inside SQL Server Query Tuning and Optimization, appears to be a multiple-author ensemble book with only 1½ chapters written by Kalen, which might be disappointing. However, the reality is that this database dream team is hand-picked by Kalen, and following Kalen's plan the book meets the high standards Kalen is known for. The flow of the information is the right way to understand and then solve query performance...