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

Ken England Microsoft Certified Systems Engineer and a Microsoft Certified Trainer (Author)

Book Description

ISBN-10: 1555582419 | ISBN-13: 978-1555582418 | Publication Date: March 13, 2001 | Edition: 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

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

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.

Product Details

• Paperback: 320 pages
• Publisher: Digital Press; 1 edition (March 13, 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 (15 customer reviews)
• Amazon Best Sellers Rank: #1,305,378 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

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 "OB-Wan" (Santa Monica, CA) - See all my reviews
(TOP 1000 REVIEWER)    (VINE VOICE)    (REAL NAME)   

Amazon Verified Purchase

This review is from: The Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook (Paperback)

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

This review is from: The Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook (Paperback)

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:

5.0 out of 5 stars Great book. Best if used in pair with inside SQL Server 2000, May 20, 2001

By 

Jesse Roberge "GreatInca" (Mesa, Arizona United States) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: The Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook (Paperback)

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.