Microsoft SQL Server 2000管理员指南 影印版PDF电子书下载

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