and over 2 million other books are available for Amazon Kindle . Learn more
  • RRP: £50.99
  • You Save: £8.21 (16%)
FREE Delivery in the UK.
In stock.
Dispatched from and sold by Amazon.
Gift-wrap available.
FREE Delivery on orders over £10.
Condition: Used: Good
Comment: This book is eligible for free delivery anywhere in the UK. Your order will be picked, packed and dispatched by Amazon. Buy with confidence!
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

The Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook Paperback – 1 Mar 2001

See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
"Please retry"
£31.55 £0.01

There is a newer edition of this item:

Trade In Promotion

Product details

More About the Author

Discover books, learn about writers, and more.

Product Description


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

About the Author

Ken England is President and Founder of Database Technologies, a database consulting, product evaluation and training firm. A Microsoft Certified Systems Engineer and a Microsoft Certified Trainer, Ken England is widely regarded as an authority on SQL Server and other leading database products. He is also the author of the SQL Server 6.5 Performance Optimization and Tuning Handbook.

Inside This Book (Learn More)
First Sentence
What is the goal of tuning a SQL Server database? Read the first page
Explore More
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star

Most Helpful Customer Reviews on (beta) 17 reviews
27 of 27 people found the following review helpful
Highly useful for experienced developers 1 Aug 2001
By Jaewoo Kim - Published on
Format: Paperback 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
If you are a DBA, this is the book 14 Jun 2001
By Lefty - Published on
Format: Paperback 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.
8 of 8 people found the following review helpful
Great book. Best if used in pair with inside SQL Server 2000 20 May 2001
By Jesse Roberge - Published on
Format: Paperback Verified Purchase
There is much overlap with the inside sql server 2000 book from microsoft but that book is more a detailed survey with a intuitive technical foucus while this book is a more pratical focus. These two books work together to form the ultimate 'book'. This book covers everything in detail and has many practical expamples, but the examples are not page fillers. It actulaly has many less pages than inside sql server.
10 of 11 people found the following review helpful
Very good introduction, light on actual tuning 10 Mar 2005
By D. Knapp - Published on
Format: Paperback Verified Purchase
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.
7 of 7 people found the following review helpful
Excellent Coverage on Indexes 20 Dec 2004
By Amazon Customer - Published on
Format: Paperback
I read this book online at ACM (by books 24x7) and was impressed with the clarity of Ken England's writing style. Finding a good reference on how SQL Server treats clustered and nonclustered indexes is no easy task, since most of the time a clustered index is described recursively (e.g. a clustered index is an an index that clusters data) and a nonclustered index is also defined based on not being clustered. That's useless. Ken makes it very clear what these differences are in terms of the data structures used, and more importanly helps you understand the ramifications. Reading this book has given me a black belt understanding of the Query Optimizer and Indexes. In fact, my first project after reading this book resulted taking a long running 8 hour query written by someone else and turning it into a 5 minute query. Needless to say I am purchasing a physical copy. Thanks Ken!
Were these reviews helpful? Let us know