Microsoft SQL Server 2000 Administrator's Companion with CD-ROM Book

Chapter 1: Overview of Microsoft SQL Server 2000 ..... 2
Chapter 2: The Microsoft Windows 2000 Platform ..... 14
Chapter 3: Roles and Responsibilities of the Microsoft SQL Server DBA ..... 34
Chapter 4: Designing a Microsoft SQL Server System ..... 54
Chapter 5: I/0 Subsystem Configuration and Planning ..... 70
Chapter 6: Capacity Planning ..... 104
Chapter 7: Installing Microsoft SQL Server ..... 144
Chapter 8: Managing Microsoft SQL Server Services ..... 162
Chapter 9: Creating Databases ..... 178
Chapter 10: Creating Database Tables ..... 204
Chapter 11: Configuring Microsoft SQL Server on the Network ..... 228
Chapter 12: Microsoft SQL Server and Microsoft Cluster Services ..... 248
Chapter 13: Introduction to Transact-SQL and SQL Query Analyzer ..... 276
Chapter 14: Retrieving Data Using Transact-SQL ..... 292
Chapter 15: Managing Tables Using Transact-SQL and Enterprise Manager ..... 334
Chapter 16: Creating and Using Defaults, Constraints, and Rules ..... 356
Chapter 17: Creating and Using Indexes ..... 398
Chapter 18: Creating and Using Views ..... 434
Chapter 19: Understanding Transactions and Transaction Locking ..... 466
Chapter 20:Understanding Advanced T-SQL ..... 492
Chapter 21: Creating and Managing Stored Procedures ..... 512
Chapter 22: Creating and Using Triggers ..... 540
Chapter 23: Accessing Microsoft SQL Server from the Internet ..... 568
Chapter 24: Loading the Database ..... 578
Chapter 25: Component Services and Microsoft Distributed Transaction Coordinator ..... 616
Chapter 26: Microsoft SQL Server Replication: Overview and Snapshot Replication ..... 634
Chapter 27: Transactional Replication ..... 694
Chapter 28: Merge Replication ..... 738
Chapter 29: Using Microsoft SQL Server Analysis Services ..... 770
Chapter 30: Microsoft SQL Server Administration ..... 808
Chapter 31: Automating Administrative Tasks ..... 836
Chapter 32: Backing Up Microsoft SQL Server ..... 872
Chapter 33: Restoring and Recovering the Database ..... 910
Chapter 34: User and Security Management ..... 926
Chapter 35: Using SQL Query Analyzer and SQL Profiler ..... 958
Chapter 36: Solving Common Performance Problems ..... 986
Appendix A: Microsoft SQL Server Configuration Parameters ..... 1012
Appendix B: Microsoft SQL Server Monitoring ..... 1030
Appendix C: DBCC Commands ..... 1042
Glossary ..... 1047
Index ..... 1063