数据库与数据仓库实用操作大全（影印版）

Acknowledgements

Part1 Introduction and Overview

Chapter2 Welcome to the SQL Server 2000 Reference Library

Creating a Failover Cluster

Upgrading to a SQL Server 2000Failover Cluster

Handling a Failover Cluster Installation

Maintaining a Failover Cluster

Using SQL Server Tools with Failover Clustering

Failover Cluster Troubleshooting

Part2 Creating and Maintaining Databases

Chapter3 Databases

Parts of a Database

Files and Filegroups

Transaction Logs

Database Design Considerations

Creating a Database Plan

Online Transaction Processing vs. Decision Support

Normalization

Data Integrity

Data Security

Databas Performance

Maintenance

Estimating the Size of a Database

Creating a Database

Using Raw Partitions

Modifying a Database

Expanding a Database

Shrinking a Database

Adding and Deleting Data and Transaction Log Files

Creating Filegroups

Changing the Default Filegroup

Setting Database Options

Creating a Removable Database

Attaching and Detaching a Database

Rendming a Database

Changing thd Database Owner

Transaction Termination for Changing Database States

Viewing a Database

Displaying Database and Transection Log Space

Documenting and Scripting Databases

Database Maintenance Plan Wizard

Deleting a Database

Chapter4 Tables

Designing Tables

Specifying a Column Data Type

Text in Row Data

Autonembering and Identifier Columns

Using Constraints，Defaults，and Null Values

Creating and Modifying a Table

Modifying Column Properties

Adding and Deleting Columns

Creating and Modifying PRIMARY KEY Constraints

Creating and Modifying FOREING KEY Constraints

Creating and Modifying UNIQUE Constraints

Creating and Modifying CHECK Constraints

Creating and Modifying DEFAULT Definitions

Creating and Modifying Identifier Columns

Viewing a Table

Deleting a Table

Chapter5 Indexes

Desingning an Index

Creating an Index

Rebuilding an Index

Renaming an Index

Viewing an Index

Deleting an Index

Chapter6 Views

Scenarios for Using Views

Creating a View

Designing an Indexed View

Creating an Indexed View

Creating a Partitioned View

Modifying and Renaming a View

Modifying Data Through a View

Getting Information About a View

Deleting a View

Chapter7 Stored Procedures

Extended Stored Procedures

Creating a Stored Procedure

Specifying Parameters

Programming Stored Procedures

Returning Data from a Stored Procedure

Executing a Stored Procedure

Automatic Execution of Stored Procedures

Modifying and Renaming a Stored Procedure

Recompiling a Stored Procedure

Viewing a Stored Procedure

Deleting a Stored Procedure

Chapter8 Enfircing Business Rules With Triggers

Designing Triggers

Specifying When a Trigger Fires

Trigger Execution

Designing INSTEAD OF Triggers

Creating a Trigger

Programming Triggers

Using Triggers that Include ROLLBACK TRANSACTION

Using the inserted and deleted Tables

Multirow Considerations

Conditional INSERT Trigger

Specifying First and Last Triggers

Using Nested Triggers

Using INSTEAD OF Triggers

Using test，ntext，and image Data in INSTEAD OF Triggers

Activating Triggers with Implicit and Explicit Null Values

Modifying and Renaming a Trigger

Viewing a Trigger

Deleting a Trigger

Chapter9 User-Defined Functions

User-Defined Functions That Return a Table Data Type

Inline User-Defined Functions

Deterministic and Nondeterministic Functions

Rewriting Stored Procedures as Functions

Using Extended Properties on Database Objects

Chapter10 Full-Text Indexes

Administering Full-Text Features Using SQL Enterprise Manager

Administering Full-Text Features Using Stored Procedures and Scalar Functions

Enabling Others to Issue Full-Text Queries

Performing Investigation and Clean-up Tasks for Full Text Catalogs

Performing Infrequent Tasks

Maintaining Full-Text Indexes

Filtering Supported File Types

Column-Level Linguistic Analysis

Part 3 Creating and Using Data Warehouses

Chapter11 Data Warehousing Overview

SQL Server 2000 Tools for Data Warehouses

Chapter12 Parts of a Data Warehouse

Data Marts

Relational Databases

Data Sources

Data Preparation Area

Presentation Services

End-User Analysis

Chapter13 Creating a Data Warehouse

Designing a Data Warehouse

Using Dimensional Modeling

Fact Tables

Aggregation Tables

Dimension Tables

Indexes

Creating the Data Preparation Area

Creating the Data Warehouse Database

Extracting Data from Operational Systems

Cleansing and Transforming Data

Loading Data into the Data Warehouse Database

Preparing presentation Information

Distributing Data to Data Marts

Chapter14 Using a Data Warehouse

SQL Queries

OLAP and Data Mining

English Query

Microsoft Office 2000

Web Access and Reporting

Offine OLAP Cubes

Third-Party Applications

Custom Applications

Chapter15 Maintaining a Data Warehouse

Updating Data Warehouse Data

Scheduling Data Updates

Synchronizing OLAP Cubes

Updating Data Marts

Administering a Data Warehouse

Backing Up Data Warehouse Data

Automating Data Warehouse Tasks

Tuning Data Warehouse Performance

Part 4 Optimizing Database Performance

Chapter16 Designging Feferated Database Servers

Designing Partitions

Designing Federated Database Servers for High Availability

Backing Up and Restoring Federated Database Servers

Chapter17 Database Design

Logical Database Design

Database Design Considerations：Data Types

Physical Database Design

RAID

Partitioning

Data Placement Using Filegroups

Index Tuning Recommendations

Optimizing Transaction Log Performance

Optimizing tempdb performance

File Systems

Chapter18 Query Tuning

Analyzing a Query

Graphically Displaying the Executin Plan Using SQL Query Analyzer

Logical and Physical Operators

Query Tuning Recommendations

Advanced Query Tuning Concepts

Understanding Nested Loops Joins

Understanding Merge Joins

Understanding Hash Joins

Chapter19 Application Design

Networking and Performance

Named Pipes vs.TCP/IP Sockets

Optimizing Application Performance Using Efficient Data Retrieval

Effects of Transactions and Batches on Application Performance

Effects of Stored Procedures on Application Performance

Understanding and Avoiding Blocking

Optimizing Distributed Queries

Chapter20 Optimizing Utility and Tool Performance

Optimizing Backup and Restore Performance

Optimizing Bulk Copy Performance

Optimizing DBCC Performance

Chapter21 Optimizing Server Performance

Optimizing Server Performance Using Memory Configuration Options

Optimizing Server Performance Using I/O Configuration Options

Optimizing Server Performance Using Windows NT Options

Maximizing Throughput

Configuring Server Tasking

Configuring Virtual Memory

Index A Topics in the SQL Server 2000 Reference Library

Index B Index of Optimizing Database Performance Elements