The SQL Server 6.5 Performance Optimization and Tuning Handbook
by Ken England
Sales Rank: 1308291
$0.40 At Amazon
Paperback: 259 pages
Publisher: Butterworth-Heinemann July 1997
Language: English
ISBN-10: 1555581803
ISBN-13: 978-1555581800
Product Dimensions:
9.2 x 7 x 0.6 inches
Shipping Weight: 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.
Customer Reviews & Comments
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!
Comment | Permalink |
(Report this)
