 See larger picture | Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook
by
Ken England
- Digital PressList Price: $66.95
Price at Amazon.com: $48.20
(Save
28%)
 Availability: Usually ships in 24 hours
Shipping rates and policies |
- Average Customer Review:
Based on
14
reviews.
- Amazon.com Sales Rank: 220843
|
Product Description 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
Featured Customer Reviews Outstanding Reference Book,
February 09, 2007 I have been a DBA for a bunch of small sites for many years. Recently I committed to a job w/ a large, online OLTP retailer and needed to fine tune my knowledge of the SQL Server engine.
I was shocked at just how flawed/lacking my knowledge was after reading this book.
Let me first state this sucker isn't for people looking to get by using the Enterprise Manger GUI. This book dissects the inner most workings of the db engine and it's under lying theory. Their is a lot of TSQL. I found myself limited to reading only a small number of pages at a time and then needing a break. The book is that intense and I have a Masters of Science degree as well as MCDBA and MCITP certifications.
Probably my favorite feature of the book is its small size, under 400 pages from tip to tail. I'd suggest this book to anyone wanting an understanding of what they are actually doing in SQL Server when they issue commands from EM. This book should be a requirement for any DBA or DB Designer in my opinion.SQL best practices bible,
January 10, 2007 I have been working with SQL for several years and always felt a bit weak in my understanding of best practices. I have only absorbed a few chapters so far on index structure and execution plans but already I feel like I have fast tracked into the clever peoples class. The layout is excellent and the language unambigous.Best overall for SQL Server Tuning,
August 02, 2006 I am a SQL Server performance consultant to many large corporations and government agencies. I have read and re-read this book so many times I should know it by heart. Still, I carry it with me on consulting engagements everywhere I go. There is almost always someone at my client's site who wants to improve their performance tuning skills. I show them the book and tell them this is where you start.
I don't know if there will be a version specifically for 2005, but it really doesn't matter much. The central concepts of the book have not changed for SQL Server 2005.
Ken England's writing style is clean and lucid. He can explain complex issues in a remarkably understandable way. His explanation of indexes and strategies of indexing is a great example of readable technical writing. He also has a good understanding of what is important and what is not.
This book is accessible to anyone who has some experience with SQL Server or any relational database. Someone with little experience may not get it all in one pass, but they will be much better prepared for real-world SQL Server performance tuning.Best book on performance tuning,
September 26, 2005 This is the best book ever written on performance tuning. Excellent text and very well written too. Thanks a lot.This book rocks!!,
August 30, 2005 This book is like a SQL SERVER 2000 bible for me. It has the most wonderful information in it, clear and easy to understand. I needed to interview for a job and I looked to this book for clarity and knowledge and boy was I enlightened. A must read for a beginner DBA like myself!!!!!
You might also be interested in these items...
|
|