SQL Server 2000 Bible

Outline

Part I: Laying the Foundation
Chapter 1: Introduction to SQL Server (30 pages)
Chapter 2: Modeling the Logical Database Schema (28 pages)
Chapter 3: Installing and Configuring SQL Server (28 pages)
Chapter 4: Using SQL Server's Developer Tools (20 pages)

Part II: Developing SQL Server Databases
Chapter 5: Implementing the Physical Schema (44 pages)
Chapter 6: Retrieving Data with Select (60 pages)
Chapter 7: Merging Data Using Relational Algebra (52 pages)
Chapter 8: Searching Full-Text Indexes (22 pages)
Chapter 9: Creating Views (14 pages)
Chapter 10: Modifying Data (32 pages)
Chapter 11: Transactional Integrity (32 pages)
Chapter 12: Programming with Transact SQL (36 pages)
Chapter 13: Developing Stored Procedures (22 pages)
Chapter 14: Building User-Defined Functions (10 pages)
Chapter 15: Implementing Triggers (14 pages)
Chapter 16: Advanced Server-Side Programming (46 pages)

Part III: Data Connectivity
Chapter 17: Transferring Databases (10 pages)
Chapter 18: Working with Distributed Data (22 pages)
Chapter 19: Migrating Data with DTS (18 pages)
Chapter 20: Replicating Databases (16 pages)
Chapter 21: ADO and ADO.NET (30 pages)
Chapter 22: XML and Web Publishing (30 pages)

Part IV: Administering SQL Server
Chapter 23: Configuring SQL Server (30 pages)
Chapter 24: Maintaining the Database (16 pages)
Chapter 25: Automating Db Maintenance w/ SQL Server Agent (16 pages)
Chapter 26: Recovery Planning (30 pages)
Chapter 27: Securing Databases (32 pages)

Parts V: Advanced Issues
Chapter 28: Advanced Performance (28 pages)
Chapter 29: Advanced Availability (14 pages)
Chapter 30: Advanced Scalability (16 pages)
Chapter 31: Analysis Services (22 pages)
Chapter 32: Advanced Portability (4 pages)

Appendix
Appendix A: Resources (2 page)
Appendix B: Sample Databases (10 pages)
Appendix C: SQL Server 2000 Specifications (4 pages)
Appendix D: What's on the CD (2 pages)

Sample Files

Chapter Code 270Kb
Sample Databases Scripts 171Kb

Errata

A few of the images in Chapter 1 were swapped
p 19 Figure 1-6: The image is shown in Figure 1-9
p 20 Figure 1-7: the image is shown in Figure 1-6
p 22 Figure 1-8: the image is shown in Figure 1-7
p 23 Figure 1-9: the image is shown in Figure 1-8

p 100 Figure 4-9 does not show the relationships

p 128 Primary Keys: in addition to the reasons given, composite primary keys also make it difficult or impossible to reference the table within a subquery using the WHERE IN syntax.

p 170 in the last paragrah, it should read, "if 1 is ever less than 0 , the realityCheck case will accurately report 'reality is gone.'

p 217 in table 7-1 - the definitions for the Full Outer Join and the Theta Join have been transposed.

p 379 the explanation of "@@Total_Write" should say, "total number of disk WRITES since..."

p 437 "The following after trigger simply prints after trigger when the trigger is executed:"
Should read:
"The following after trigger simply prints In the After Trigger when the trigger is executed:"