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