The SQL Server 6 5 Performance Optimization and Tuning Handbook
The SQL Server 6.5 Performance Optimization and Tuning Handbook takes a detailed look at the factors that influence database performance, beginning with good physical design. The internal storage... This description may be from another edition of this product.
Format:Paperback
Language:English
ISBN:1555581803
ISBN13:9781555581800
Release Date:August 1997
Publisher:Butterworth-Heinemann
Length:259 Pages
Weight:1.05 lbs.
Dimensions:0.6" x 7.0" x 9.2"
Customer Reviews
5 ratings
Clear, practical information
Published by Thriftbooks.com User , 25 years ago
This book completely demystifies a number of SQL tuning concepts. This book provides a superb overview of the various performance topics, and then drills down deep enough into the concepts to give you the insights necessary to tackle thorny performance problems with multiple causes. This is still a very valuable book for SQL 7.0--the majority of the concepts are still with us.
Well done...
Published by Thriftbooks.com User , 26 years ago
This book is one of many I have read on SQL Server 6.5. It is clear & very well written. It highlights key points and goes into the right amount of detail. It is a must-read for anyone designing, deploying, or administering a SQL SERVER 6.5 database.
Short, Sweet, and Meaty
Published by Thriftbooks.com User , 26 years ago
After you have spent 8-80 hours trying random combo's on the Server Configuration panel trying to guess what you should do, buy this book and score a direct hit! Microsoft should bundle this book with SQL Server. If a little more detail were provided on the internal data structures of SQL Server one could write a bulk loader that bypassed SQL Server entirely (I know its been done by others) and load 10 X as fast. (hint-hint) This is the closest thing to a K & R for MS SQL Server I've ever seen. I really like the brevity of this book. Every word counts! Very, very good job Ken!
Excellent
Published by Thriftbooks.com User , 26 years ago
The techniques described in this book are effective and well thought out. Even if performance optimization is not your main goal, this book is well worth reading. The book delivers in-depth information on indexing, locking, the optimizer and many other topics in a very readable format. Ideal for those with some knowledge of SQL Server who want to dig deeper.
Great book
Published by Thriftbooks.com User , 26 years ago
Had response problems with current database setup and SQL statements. The chapters on Indexing and Optimizing really work. Ex. A simple query on two tables took 2.5 minutes. After applying some of the suggestions, the query took a little over 2 seconds...
Copyright © 2025 Thriftbooks.com
Terms of Use | Privacy Policy | Do Not Sell/Share My Personal Information | Cookie Policy | Cookie Preferences | Accessibility Statement
ThriftBooks ® and the ThriftBooks ® logo are registered trademarks of Thrift Books Global, LLC
ThriftBooks ® and the ThriftBooks ® logo are registered trademarks of Thrift Books Global, LLC
