Microsoft Press, 2001. — 1046 p.
This is the definitive companion to Microsoft SQL Server 2000. The authors have combined the perspectives of the developer and the user into a readable and comprehensive guide. Ron Soukup led the SQL Server development team for a decade, and he continues to be one of its key architects. Kalen Delaney has been working with the application designers and developers for almost that long. This is their guide to why SQL Server is the way it is, and how it should be used. The guide complements the reference material in SQL Server Books Online.
The Evolution of Microsoft SQL Server: 1989 to 2000
A Tour of SQL Server
SQL Server Architecture
Planning For and Installing SQL Server
Databases and Database Files
Tables
Querying Data
Indexes
Modifying Data
Programming with Transact-SQL
Batches, Stored Procedures, and Functions
Transactions and Triggers
Special Transact-SQL Operations: Working with Cursors and Large Objects
Locking
The Query Processor
Query Tuning
Configuration and Performance Monitoring