The SQL Server 6.5 Performance Optimization and Tuning Handbook

Features

• Cover Type: Paperback with 259 pages
• Published by: Butterworth-Heinemann July 1997
• Written in: English
• ISBN 10 Number: 1555581803
• ISBN 13 Number: 978-1555581800
• Book Dimensions: 9.2 x 7 x 0.6 inches
• Weighs: 15.2 ounces

Book Description
* Follow up to The SQL Server Handbook

* Detailed look at factors that influence database performance

* Covers internal storage structures, indexes, and integrating SQL with Windows NT

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 structures are covered next, because an understanding of these is essential to performance tuning. The critical subject of indexes is then discussed, followed by the query optimizer, which is perhaps the most crucial SQL Server performance topic. Making mistakes in these areas can mean the difference between a query taking seconds or literally hours.

Book Info
Takes a detailed look at the factors that influence database performance, beginning with good physical design. Introduces internal storage structures of SQL server and discusses indexes and query optimizer and integrating SQL with Windows NT. Paper. DLC: Client/server computing.

Reader Reviews
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 ten 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!