The Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook (Paperback)

~ Ken England Microsoft Certified Systems Engineer and a Microsoft Certified Trainer (Author) "What is the goal of tuning a SQL Server database?..." (more)
Key Phrases: key distribution statistics, estimated query execution plan, clustered index present, Server Enterprise Manager, Index Tuning, Bookmark Lookup (more...)

Editorial Reviews

Review

This book provides tools, techniques, and best practices that you can use to tune SQL Server's configuration and operation.
-SQL Server

This book is a real gem and derserves a wide audience - Joe Karam, MCSD, MCDBA, MCT -- Review

Review

This book provides tools, techniques, and best practices that you can use to tune SQL Server's configuration and operation.
-SQL Server

This book is a real gem and derserves a wide audience - Joe Karam, MCSD, MCDBA, MCT

See all Editorial Reviews

Product Details

• Paperback: 320 pages
• Publisher: Digital Press; 1st edition (March 27, 2001)
• Language: English
• ISBN-10: 1555582419
• ISBN-13: 978-1555582418
• Product Dimensions: 9 x 7 x 1 inches
• Shipping Weight: 1.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.8 out of 5 stars  See all reviews (14 customer reviews)
• Amazon.com Sales Rank: #615,373 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #35 in

  Books > Computers & Internet > Programming > Software Design, Testing & Engineering > Performance Optimization

Customer Reviews

Most Helpful Customer Reviews

27 of 27 people found the following review helpful:

5.0 out of 5 stars Highly useful for experienced developers, August 1, 2001

By	Jaewoo Kim (Santa Monica, CA) - See all my reviews (REAL NAME)

Amazon Verified Purchase

What I really like about this book is that it is cheap compared to its competitors. The author does not waste paper with wordy sentences that is only meant to take up space to create a 1500+ book to justify a price.

The author explains three things in depth and better than any books I have ever read (and I have read lot of SQL books): Index optimization, query optimization, and locking.

These three topics are usually for advanced SQL developers who must performance tune a complex database. This book is not for the beginners. Having said this, if you want to be a serious database developer, this book will put you ahead of your competition. I highly recommend it to anyone who wants to be or is a database developer.

16 of 16 people found the following review helpful:

5.0 out of 5 stars If you are a DBA, this is the book, June 14, 2001

By	Lefty "Lefty" (TX USA) - See all my reviews

Amazon Verified Purchase

I have been amazed about how much information is in this book. The writing is clear and concise. The long section that details query tuning was an education in itself.

I finished the book with a clear understanding of the types of queries and how SQL Server uses them.

This book is sitting on my desk now. If you want the information on how to optimize your queries, or the database, this is my recommendation.

9 of 9 people found the following review helpful:

2.0 out of 5 stars Very good introduction, light on actual tuning, March 10, 2005

By	D. Knapp "SQL DBA" (Virginia) - See all my reviews (REAL NAME)

This book contains very clear introductions on how SQL server 2000 works, what are the important design considerations for creating a database, and has tutorials on the various tuning tools. As an introduction on SQL Server workings, it is very good. However, it is also very light on how to actually monitor and tune a real system. The tuning checklist is generic and many of the items are only applicable to designers, not someone who administers databases that may have been in existance for years. If you read the entire book, you can pick out handy items, but it does not give tuning examples, does not tell when to get concerned over particular parameters, nor go into which parameters (from the many supplied by the performance monitor) are really the important ones. As such, I did not find it much help in my daily activities as a DBA. I found "SQL Server 2000 for Experienced DBAs" by Brian Knight to be much more helpful.