Microsoft SQL Server 2000 管理员指南
分類: 图书,计算机/网络,数据库,SQL,
作者: Microsoft 公司著
出 版 社:
出版时间: 2001-5-1字数:版次: 1版1次页数: 1130印刷时间:开本:印次:纸张:I S B N : 9787900629784包装: 精装内容简介
本书面向大、中、小型机构,介绍中SQL Server 2000的部署、管理和支持过程中涉及的各种常用技能,包括安装前的准备工作,安装和配置及其所用的工具,SQL、T-SQL、DDL 及DML 的用途,内置的特性,用以简化SQL Serever 2000管理的特性及工具,等等。
目录
1,Overview of Microsoft SQL Server 2000
2,The Microsoft windows 2000 Platform
3,Roles and Responsibilities of the Microsoft SQL Server DBA
4,designing a Microosft SQL Server System
5,I/O Subsystem Configuration and Planning
6,Capacity Planning
7,Installing Microsoft SQL Server
8,Managing Microsoft SQL Server Services
9,Creating Databases
10,Creating Database Tables
11,Configuring Microsoft SQL Server on the Network
12,Microsoft SQL Server and Microsoft Cluster Services
13,Introduction to Transact-SQL and SQL Query Analyzer
14,Retrieving data Using Transact-SQL
15,Managing Tables Using Transact-SQL and Enterprise Manager
16,Creating and Using Defaults,constraints,and Rules
17,Creatig and Using Indexes
18,Creating and Using views
19,Understanding Transactions and Transaction Locking
20,Understanding advanced T-SQL
21,Creating and Managing Stored Procedures
22,Creating and Using Triggers
23,Accessing Microsoft SQL Server From the Internet
24,Loading the Database
25,Component services and Microsoft Distributed Transaction coordinator
26,Microsoft SQL Server Replication:Overview and Snapshot Replication
27,Transactional Replication
28,Merge Replication
29,Using Microsoft SQL Server Analysis Services
30,Microsoft SQL Server Administration
31,Automating Administrative Tasks
32,Backing up Microsoft SQL Server
33,Restoring and Recovering the Database
34,User and Security Management
35,Using SQL Query Analyzer and SQL Profiler
36,Solving common Performance Problems
A,Microsoft SQL Server configuration Parameters
B,Microsoft SQL Server Monitoring
C,DBCC Commands