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
鄂公网安备 42010302001612号 