SQL Server 2000 Programming

By far, this is the best overall MS SQL 2000 server book written until today. Most topics are covered from basic to advance level. This book is a must have for anyone who is looking to get a well rounded knowledge of what’s possible with MS SQL 2000.

The chapters I liked the most are:
Ch9 SQL Server Storage and Index Structures
Ch10 Views
Ch12 Stored Procedures
Ch15 Triggers
Ch16 Advanced Queries
Ch26 Full-Text Search
Ch29 Performance Tuning
All Appendixes

Noticed that I said “best overall” & “Most topics”; this book will not have an answer for very advance topics in areas like DTS, performance tuning, XML, & Analysis Services. There are great books out there if what you are looking for is not in Professional SQL Server 2000 Programming. The “Professional SQL Server 2000 DTS” is the best I have read when it comes to Data Transformation Services. For performance tuning and XML you may find books written by Ken Henderson to be among the best. For Analysis Services I have not found one book I will recommend yet.