Qty:1
  • List Price: $82.95
  • Save: $6.51 (8%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
The Microsoft SQL Server ... has been added to your Cart
Condition: Used: Very Good
Comment: Eligible for FREE Super Saving Shipping! Fast Amazon shipping plus a hassle free return policy mean your satisfaction is guaranteed! Tracking number provided with every order. Light shelf wear; otherwise item is in very good condition;
Access codes and supplements are not guaranteed with used items.
Have one to sell? Sell on Amazon
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 – March 27, 2001

ISBN-13: 978-1555582418 ISBN-10: 1555582419 Edition: 1st

Buy New
Price: $76.44
20 New from $15.50 37 Used from $0.01 1 Collectible from $9.96
Rent from Amazon Price New from Used from
Kindle
"Please retry"
$16.35
Paperback
"Please retry"
$76.44
$15.50 $0.01

There is a newer edition of this item:

Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Get Up to 80% Back When You Sell Us Your Books
$76.44 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

The Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook + Microsoft SQL Server 2008 Internals (Developer Reference)
Price for both: $118.43

Buy the selected items together
NO_CONTENT_IN_FEATURE
Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 320 pages
  • Publisher: Digital Press; 1 edition (March 27, 2001)
  • Language: English
  • ISBN-10: 1555582419
  • ISBN-13: 978-1555582418
  • Product Dimensions: 7 x 1 x 9.2 inches
  • Shipping Weight: 1.4 pounds (View shipping rates and policies)
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (18 customer reviews)
  • Amazon Best Sellers Rank: #1,474,138 in Books (See Top 100 in Books)

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.

Customer Reviews

4.6 out of 5 stars
5 star
78%
4 star
11%
3 star
0%
2 star
11%
1 star
0%
See all 18 customer reviews
The writing is clear and concise.
Lefty
I highly recommend it to anyone who wants to be or is a database developer.
Jaewoo Kim
I have read and re-read this book so many times I should know it by heart.
Kurt Survance

Most Helpful Customer Reviews

27 of 27 people found the following review helpful By Jaewoo Kim VINE VOICE on August 1, 2001
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
16 of 16 people found the following review helpful By Lefty on June 14, 2001
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 8 people found the following review helpful By Jesse Roberge on May 20, 2001
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
10 of 11 people found the following review helpful By D. Knapp on March 10, 2005
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 7 people found the following review helpful By Amazon Customer on December 20, 2004
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!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
15 of 18 people found the following review helpful By Scott M. Dexter on December 5, 2002
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 11 people found the following review helpful By Amazon Customer on March 24, 2002
Format: Paperback Verified Purchase
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews


More About the Author

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

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
The Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook
This item: The Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook
Price: $82.95 $76.44
Ships from and sold by Amazon.com