|
Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook
 |
Author: Ken England
List Price: $47.95
Our Price: Click to see the latest and low price
ISBN: 1555582419
Publisher: Digital Press (15 March, 2001)
Edition: Paperback
Sales Rank: 1,786
Average Customer Rating: 5 out of 5
|
Customer ReviewsRating: 5 out of 5
Excellent Book. Period !!
Very useful book for query tuning, optimization etc.
(for both SQL server and Sybase)
Period.
Rating: 5 out of 5
Light on Fluff Heavy on Stuff
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.
Rating: 5 out of 5
Not Disappointed!
...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.
Similar Products
· Microsoft SQL Server 2000 Performance Tuning Technical Reference
· Microsoft SQL Server 2000 Unleashed (2nd Edition)
· Professional SQL Server 2000 Programming
· The Guru's Guide to Transact-SQL
· The Guru's Guide to SQL Server Stored Procedures, XML, and HTML (With CD-ROM)
|
