and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.

Sign in to turn on 1-Click ordering.
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Start reading The Microsoft SQL Server 2000 Performance Optimization an... on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

The Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook [Paperback]

Ken England
5.0 out of 5 stars  See all reviews (7 customer reviews)
List Price: CDN$ 89.02
Price: CDN$ 83.12 & FREE Shipping. Details
You Save: CDN$ 5.90 (7%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Want it delivered Thursday, September 25? Choose One-Day Shipping at checkout.


Amazon Price New from Used from
Kindle Edition CDN $53.95  
Paperback CDN $83.12  
Save Up to 90% on Textbooks
Hit the books in's Textbook Store and save up to 90% on used textbooks and 35% on new textbooks. Learn more.
There is a newer edition of this item:
Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook
CDN$ 62.20
In Stock.
Join Amazon Student in Canada

Book Description

March 13 2001 1555582419 978-1555582418 1
Learn from a SQL Server performance authority how to make your database run at lightning speed.

Ken England's SQL Server 6.5 Performance Optimization and Tuning Handbook is recognized by SQL Server administrators as the indispensable guide to tuning and optimization. Now he's revised the book for Microsoft's new SQL Server 2000, the most advanced and powerful version yet of SQL Server, which takes full advantage of Windows 2000's new processing capabilities. The book details the factors that determine database performance and offers readers tools, techniques and best practices they can use to tweak and tune SQL Server's configuration and operation. Readers will learn how to enhance performance through good physical design and effective internal storage structures. The book spells out methods for creating efficient indexes and techniques for tuning SQL Server's new query optimizer.

A new edition of the authoritative and bestselling guide, SQL Server 6.5 Performance Optimization and Tuning Handbook, 1555581803Targets SQL Server 2000Helps IT professionals run SQL Server more powerfully and efficiently and optimize it for e-commerce and knowledge management

Special Offers and Product Promotions

  • Join Amazon Student in Canada

Customers Who Bought This Item Also Bought

Product Details

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

4 star
3 star
2 star
1 star
5.0 out of 5 stars
5.0 out of 5 stars
Most helpful customer reviews
5.0 out of 5 stars Light on Fluff Heavy on Stuff Dec 5 2002
I would say this this is one of my favorite SQL Server books and I have alot. If you want plain english internals, query optimization, information on locking and the things to think about when you are designing a new system or improving an old one, then Ken England has the book for you. I agree with another reader that this book reads like Ken is in the room talking to you. What is my favorite part...the part on the default data cache which if you are a Sybase DBA or a guy from way back this is something that they teach you right away and you would configure yourself along with the stored procedure cache. In SQL 2000 they are integrated and have been for a while but Ken does a real nice job of explaining them so that you can understand the need for memory how things come in and out of memory etc. I also like how he gets you to ask yourself the same questions that he asks himself, " Is this going to cause a locking problem in the future." I would say that If you want a book that is down and dirty to the point for every DBA to learn about and understand sql server and how to optimize it, look no further all of the essentials that you wished that you had known years ago are here. While there are other good authors out there like, Kalen Delaney, Rob Vieira, Mike Otey, Ken Henderson, etc.. This book is in the catagory of.. You need to have it and know everything in it. Any DBA worth their weight would own this book.
Was this review helpful to you?
5.0 out of 5 stars Best SQL Server Book I've Seen March 24 2002
If you want to really understand SQL Server, and get a better insight on database technology in general, this is the book to read. Ken England covers everything from SQL Server's internal workings (how it accesses tables & indexes) to query and index optimization. This is the kind of thing they don't teach you in college. Real-world, useful examples and techniques abound in this book. For instance, England goes over a few undocumented DBCC commands and includes an extended section on using the query execution plan to fine-tune indexes and queries. Also covered is the use of lock hints (as well as the underlying technology), hardware considerations, and a lot more.
That said, I would recommend this book to anyone who deals with SQL Server on ANY level, from DBA's to web developers. Pair this book with The Guru's Guide to Transact-SQL by Ken Henderson and you've got a great start on real database development.
Was this review helpful to you?
5.0 out of 5 stars Highly useful for experienced developers Aug. 1 2001
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.
Was this review helpful to you?
5.0 out of 5 stars Not Disappointed! April 18 2002
By somuch
...This covers what some of the other tuning books covers - but every book shows you something the others don't. This book showed me quite a few undocumented commands and tips I didn't get from other books.
I think what I liked best about it was the writing style. It doesn't read like a technical manual or textbook... it reads more like Ken England is talking to you personally. He explains concepts and techniques in a way that even I could understand. I highly recommend this book.
Was this review helpful to you?
Want to see more reviews on this item?

Look for similar items by category