Product Details
Inside Microsoft SQL Server 2005: Query Tuning & Optimization: Query Tuning and Optimization

Inside Microsoft SQL Server 2005: Query Tuning & Optimization: Query Tuning and Optimization
By S. Agarwal, C. Freedman, A. Machanic, R. Talmage Kalen Delaney

List Price: £39.49
Price: £22.43 & eligible for FREE Super Saver Delivery on orders over £5. Details

Availability: Usually dispatched within 24 hours
Dispatched from and sold by Amazon.co.uk

34 new or used available from £9.36

Average customer review:

Product Description

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 

Product Details

  • Amazon Sales Rank: #253731 in Books
  • Published on: 2007-10-02
  • Original language: English
  • Number of items: 1
  • Binding: Paperback
  • 448 pages

Editorial Reviews

About the Author
Kalen Delaney, Series Editor for the Inside SQL Server line of books, has been working with SQL Server for two decades. She is a well-known expert in the SQL Server community and has been a Microsoft MVP since 1995. Kalen is a contributing editor and columnist for SQL Server Magazine and the author of several books, including Inside Microsoft SQL Server 2000.

Customer Reviews

quite good4
I read this book after "Inside SQL Server 2005: TSQL Querying" and I was not as impressed.
"TSQL Querying" uses some (invaluable) techniques that could run on SQL 2000 as well as 2005 specific stuff.
This book, on the other hand, is pretty much 2005 only BUT I did not think it had so much "impact".
I learned some very interesting stuff regarding DMVs (Dynamic Management Views) but I did not feel it deserved an entire book.
After that long wait (the book was delayed many times), it was a bit of an anticlimax.
It is a useful read but TSQL Querying seems much better to me