 |
Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook View Larger Image | Ken England
Digital Press, Paperback, Published March 2001, 390 pages, ISBN 1555582419 | List Price: $66.95
Our Price: $46.50
You Save: $20.45 (31% Off)
| | | Availability: Out-Of-Stock |
Customer Reviews: 1 Average Customer Rating:  Write a Review and tell the world about this title! People who purchase this book frequently purchase: - Inside Microsoft SQL Server 2000; Kalen Delaney, $35.95, 40% Off!
- SQL Server Query Performance Tuning Distilled, 2nd Edition; Sajal Dam, $30.50, 39% Off!
- Microsoft SQL Server 2000 DBA Survival Guide; Mark Spenik, et al, $34.95, 36% Off!
- The Guru's Guide to Transact-SQL; Ken Henderson, $40.95, 37% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
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.
Contents
Preface; Introducing Performance Tuning and Physical Database Design; SQL
Server Storage Structures; Indexing; The Query Optimizer; SQL Server and Windows
NT; Transactions and Locking; Monitoring Performance; A Performance Tuning Checklist
Customer Reviews
Customer Reviews: 1 Average Customer Rating: Jun 2, 2006 Sanjit (gsbajwa@yahoo.com) from Atlanta, GA
Excellent Performance Tuning Guide.
Ken England has a very good command of the concepts of performance tuning in SQL server. One of the best things in the book is the topic about distribution statistics on columns. Query optimization is also covered in great depth. 5 stars from me.
|
|
