and over one million other books are available for Amazon Kindle. Learn more
CDN$ 78.95
Only 1 left in stock (more on the way).
Ships from and sold by Amazon.ca.
Gift-wrap available.
Quantity:1
Add to Cart
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 – Mar 13 2001


Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
CDN$ 78.95
CDN$ 63.40 CDN$ 0.76

Join Amazon Student in Canada


NO_CONTENT_IN_FEATURE

Product Details

  • Paperback: 320 pages
  • Publisher: Digital Press; 1 edition (March 13 2001)
  • Language: English
  • ISBN-10: 1555582419
  • ISBN-13: 978-1555582418
  • Product Dimensions: 2.1 x 17.6 x 23.2 cm
  • Shipping Weight: 635 g
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (7 customer reviews)
  • Amazon Bestsellers Rank: #1,690,171 in Books (See Top 100 in Books)
  • See Complete Table of Contents


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

Customer Reviews

5.0 out of 5 stars
5 star
7
4 star
0
3 star
0
2 star
0
1 star
0
See all 7 customer reviews
Share your thoughts with other customers

Most helpful customer reviews

By A Customer on July 1 2003
Format: Paperback
Very useful book for query tuning, optimization etc.
(for both SQL server and Sybase)
Period.
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.
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.
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.
By somuch on April 18 2002
Format: Paperback
...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? 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.
Format: Paperback
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? 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.


Feedback