Microsoft® SQL Server™ 2000 Reference Library

Author David Iseminger, Series Editor Pages 4512 Disk N/A Level All Levels Published 11/29/2000 ISBN 9780735612808 ISBN-10 0-7356-1280-3 Price(USD) $179.99 To see this book's discounted price, select a reseller below.	More Information About the Book Table of Contents Sample Chapter Index Related Series Related Books About the Author Support: Book & CD Rate this book

Index Topics in the SQL Server 2000 Reference Library

First, this index does not contain a listing of all topics in Books Online. This index contains only topics found in the SQL Server 2000 Reference Library. This approach enables you to quickly identify whether you can find the information in one of the volumes in the SQL Server 2000 Reference Library, or whether you have to return the electronic version of Books Online to read more about the topic.

How would you use this index? Say you’re reading through a chapter in this library, and you come across text that refers you to another topic, such as the following:

Related Topics

Building and Processing Cubes, Updating Cubes and Dimensions

Or something like the following:

…For more information about which editions support which features, see Features Supported by the Editions of SQL Server 2000.

You can then look through this alphabetical listing of topics included in this library for the referenced topic, and when you find it, you’ll be directed to the Volume and Chapter where that topic can be found, as shown here:

Building and Processing Cubes		Volume 3, Chapter 5
Building and Processing Cubes		Volume 3, Chapter 8
Features Supported by the Editions of SQL Server 2000		Volume 1, Chapter 11

If two topics with the same title exist (as shown here), each will be listed separately. Although most of the references in this library will refer to topics also found in this library, you might come across topic refereces that aren’t found in this index. If so, you’ll need to go to Books Online to get more information about those topics. There are some exceptions, though, so read on.

Second, T-SQL statements and other programming elements are not included in this index. That’s because each volume that contains programming elements (such as T-SQL stored procedures, or English Query statements) has its own index of programming elements. Rather than cluttering this index up with programming elements (or vice versa), I’ve provided separate indexes to help you find the information you need faster.

Symbol
(All) Level and All Member  Volume 3, Chapter 3

Numeric
7.0 Analysis Services Client and Local Cube Support  Volume 3, Chapter 2

A
About Data Warehouses  Volume 3, Chapter 4
About Hardware-Based Solutions  Volume 2, Chapter 17
About OLAP  Volume 3, Chapter 4
About Windows NT- and Windows 2000-Based Disk Striping and Striping with Parity  Volume 2, Chapter 17
About Windows NT-Based Disk Mirroring and Duplexing  Volume 2, Chapter 17
Access Subscribers  Volume 4, Chapter 9
Accessing Database Objects Using HTTP  Volume 1, Chapter 13
Accessing SQL Server Using HTTP  Volume 1, Chapter 13
Actions  Volume 3, Chapter 3
Activating Triggers with Implicit and Explicit Null Values  Volume 2, Chapter 8
Active Directory Integration  Volume 1, Chapter 5
Active Directory Services  Volume 4, Chapter 4
ActiveX Controls for Replication  Volume 4, Chapter 8
Adding a Multiple-Column Measure to a Cube  Volume 3, Chapter 5
Adding and Deleting Columns  Volume 2, Chapter 4
Adding and Deleting Data and Transaction Log Files  Volume 2, Chapter 3
Adding Connections and Other Tasks to the Package  Volume 3, Chapter 5
Adding Hierarchies to Existing Dimensions  Volume 3, Chapter 5
Adding Question Builder to an English Query Application  Volume 4, Chapter 15
Additional Relationships  Volume 4, Chapter 16
Adjective Phrasings in Relationships  Volume 4, Chapter 15
Administering a Data Warehouse  Volume 2, Chapter 15
Administering Analysis Services  Volume 3, Chapter 5
Administering and Monitoring Replication  Volume 4, Chapter 8
Administering Full-Text Features  Volume 2, Chapter 10
Administering Full-Text Features Using Stored Procedures and Scalar Functions  Volume 2, Chapter 10
Administration Architecture  Volume 1, Chapter 8
Administrative Tasks  Volume 3, Chapter 5
Administrative Tools  Volume 3, Chapter 5
Administrator Security  Volume 3, Chapter 3
Administrator's Reference  Volume 3, Chapter 6
Advanced Data Mining Model Operations  Volume 3, Chapter 5
Advanced MDX  Volume 3, Chapter 7
Advanced Query Tuning Concepts  Volume 2, Chapter 18
Agent Login Security  Volume 4, Chapter 10
Agent Profiles  Volume 4, Chapter 8
Agents and Monitors  Volume 4, Chapter 1
Aggregate  Volume 2, Chapter 18
Aggregate Functions  Volume 3, Chapter 3
Aggregation Tables  Volume 2, Chapter 13
Aggregations  Volume 3, Chapter 3
Allocating Threads to a CPU  Volume 1, Chapter 7
Allowing Null Values  Volume 2, Chapter 4
Alternate Snapshot Locations  Volume 4, Chapter 5
Alternate Synchronization Partners  Volume 4, Chapter 6
Analysis Manager  Volume 3, Chapter 5
Analysis Server  Volume 3, Chapter 3
Analysis Server:Agg Cache Object  Volume 3, Chapter 5
Analysis Server:Connection Object  Volume 3, Chapter 5
Analysis Server:Last Query Object  Volume 3, Chapter 5
Analysis Server:Locks Object  Volume 3, Chapter 5
Analysis Server:Proc Aggs Object  Volume 3, Chapter 5
Analysis Server:Proc Indexes Object  Volume 3, Chapter 5
Analysis Server:Proc Object  Volume 3, Chapter 5
Analysis Server:Query Dims Object  Volume 3, Chapter 5
Analysis Server:Query Object  Volume 3, Chapter 5
Analysis Server:Startup Object  Volume 3, Chapter 5
Analysis Services Architecture  Volume 3, Chapter 3
Analysis Services Features  Volume 3, Chapter 3
Analysis Services in English Query  Volume 4, Chapter 16
Analysis Services Overview  Volume 3, Chapter 1
Analysis Services Requirements for (All) Level  Volume 4, Chapter 16
Analyzing a Query  Volume 2, Chapter 18
Analyzing and Optimizing Performance  Volume 3, Chapter 5
Analyzing and Optimizing Performance  Volume 3, Chapter 8
Analyzing Usage Patterns  Volume 3, Chapter 5
Annotations to the XDR Schema  Volume 1, Chapter 14
Anonymous Subscriptions  Volume 4, Chapter 5
Answer Property  Volume 4, Chapter 17
AnswerCmd Object  Volume 4, Chapter 17
Application Design  Volume 2, Chapter 19
Application Development Architecture  Volume 1, Chapter 10
Applying the Initial Snapshot  Volume 4, Chapter 5
Archiving an Analysis Services Database  Volume 3, Chapter 5
Archiving and Restoring Databases  Volume 3, Chapter 5
Archiving and Restoring Databases Between Versions of Analysis Services  Volume 3, Chapter 2
Archiving, Restoring, and Copying Data  Volume 3, Chapter 5
Archiving, Restoring, and Copying Data  Volume 3, Chapter 8
Assert  Volume 2, Chapter 18
Associating Entities  Volume 4, Chapter 15
Attachable Subscription Databases  Volume 4, Chapter 5
Attaching a Single-File Database  Volume 2, Chapter 3
Attaching a Subscription Database  Volume 4, Chapter 5
Attaching and Detaching a Database  Volume 2, Chapter 3
Attaching Databases with Anonymous Subscriptions  Volume 4, Chapter 5
Attaching Databases with Named Subscriptions  Volume 4, Chapter 5
Authentication Methods  Volume 3, Chapter 3
Authentication of Connections  Volume 3, Chapter 3
Authentication of Direct Connections  Volume 3, Chapter 3
Authoring Methods Summary  Volume 4, Chapter 17
Authoring Object Model  Volume 4, Chapter 17
Authoring Object Model Diagram  Volume 4, Chapter 17
Authoring Objects Summary  Volume 4, Chapter 17
Authoring Properties Summary  Volume 4, Chapter 17
Authoring Sample Script  Volume 4, Chapter 17
Authoring with Semantic Modeling Format  Volume 4, Chapter 15
Automated Administration Architecture  Volume 1, Chapter 8
Automatic Clarification of Questions  Volume 4, Chapter 15
Automatic Execution of Stored Procedures  Volume 2, Chapter 7
Automating a Response to an Alert  Volume 4, Chapter 8
Automating and Scheduling Administrative Tasks  Volume 3, Chapter 5
Automating and Scheduling Administrative Tasks  Volume 3, Chapter 8
Automating Data Warehouse Tasks  Volume 2, Chapter 15
AutoModel Method  Volume 4, Chapter 17
Autonumbering and Identifier Columns  Volume 2, Chapter 4
Auto-Parameterization  Volume 1, Chapter 7
Axis and Slicer Dimensions  Volume 3, Chapter 7

B
Backing Up and Restoring Federated Database Servers  Volume 2, Chapter 16
Backing Up and Restoring Replication Databases  Volume 4, Chapter 12
Backing Up Data Warehouse Data  Volume 2, Chapter 15
Backup Devices  Volume 1, Chapter 8
Backup/Restore Architecture  Volume 1, Chapter 8
Backward Compatibility  Volume 3, Chapter 2
Balanced and Unbalanced Hierarchies  Volume 3, Chapter 3
Basic MDX  Volume 3, Chapter 7
Basic Syntax of the FOR XML Clause  Volume 1, Chapter 16
Batch Processing  Volume 1, Chapter 7
Before Administering Analysis Services  Volume 3, Chapter 5
Binary Data  Volume 2, Chapter 4
Bookmark Lookup  Volume 2, Chapter 18
Browsing an Unprocessed Cube  Volume 3, Chapter 5
Browsing Cube Data  Volume 3, Chapter 5
Browsing Writeback Data  Volume 3, Chapter 5
Build Method  Volume 4, Chapter 17
Building a Cube with the Editor  Volume 3, Chapter 5
Building a Cube with the Wizard  Volume 3, Chapter 5
Building a Distributed Partitioned Cube  Volume 3, Chapter 5
Building a Linked Cube  Volume 3, Chapter 5
Building a Real-Time Cube  Volume 3, Chapter 5
Building a Virtual Cube  Volume 3, Chapter 5
Building and Processing Cubes  Volume 3, Chapter 5
Building and Processing Cubes  Volume 3, Chapter 8
Building and Using Data Mining Models  Volume 3, Chapter 5
Building Caches in MDX  Volume 3, Chapter 7
Building Calculated Cells in MDX  Volume 3, Chapter 7
Building Calculated Members in MDX  Volume 3, Chapter 7
Building Cubes  Volume 3, Chapter 5
Building Named Sets in MDX  Volume 3, Chapter 7
Business Objectives and Requirements  Volume 4, Chapter 2

C
Calculated Cells  Volume 3, Chapter 3
Calculated Members  Volume 3, Chapter 3
Caption Property  Volume 4, Chapter 17
Cascading Referential Integrity Constraints  Volume 2, Chapter 4
Cell Properties  Volume 3, Chapter 3
Cell Security  Volume 3, Chapter 3
Cells  Volume 3, Chapter 3
Central Publisher  Volume 4, Chapter 2
Central Publisher with Remote Distributor  Volume 4, Chapter 2
Central Subscriber  Volume 4, Chapter 2
Changing Collations  Volume 1, Chapter 6
Changing Dimensions  Volume 3, Chapter 3
Changing Properties of an Analysis Services Processing Task  Volume 3, Chapter 5
Changing the Database Owner  Volume 2, Chapter 3
Changing the Default Filegroup  Volume 2, Chapter 3
Character Data  Volume 2, Chapter 4
CHECK Constraints  Volume 2, Chapter 4
Checkpoints and the Active Portion of the Log  Volume 1, Chapter 6
Choosing a Resolver  Volume 4, Chapter 3
Choosing an API  Volume 1, Chapter 10
ClarifySpellingErrors Property  Volume 4, Chapter 17
Cleansing and Transforming Data  Volume 2, Chapter 13
ClearContext Method  Volume 4, Chapter 17
Client and Server Net-Libraries  Volume 1, Chapter 5
Client Architecture  Volume 3, Chapter 3
Client Components  Volume 1, Chapter 5
Client Connectivity Enhancements in PivotTable Service  Volume 3, Chapter 1
Client Network Utility  Volume 1, Chapter 8
Close Method  Volume 4, Chapter 17
Closed Property  Volume 4, Chapter 17
Clustered Index Delete  Volume 2, Chapter 18
Clustered Index Insert  Volume 2, Chapter 18
Clustered Index Scan  Volume 2, Chapter 18
Clustered Index Seek  Volume 2, Chapter 18
Clustered Index Update  Volume 2, Chapter 18
Clustered Indexes  Volume 1, Chapter 6
CmdID Property  Volume 4, Chapter 17
Collapse  Volume 2, Chapter 18
Collations  Volume 1, Chapter 6
Column Filters  Volume 4, Chapter 6
Column-Level Linguistic Analysis  Volume 2, Chapter 10
COM Custom Resolvers  Volume 4, Chapter 3
Command Object  Volume 4, Chapter 17
CommandName Property  Volume 4, Chapter 17
CommandResponse Object  Volume 4, Chapter 17
Commands  Volume 3, Chapter 3
Commands Collection  Volume 4, Chapter 17
Comments in MDX  Volume 3, Chapter 7
Communicating with Multiple Instances  Volume 1, Chapter 5
Communication Components  Volume 1, Chapter 5
Comparing Different Implementations of RAID Levels  Volume 2, Chapter 17
Comparison of SQL and MDX  Volume 3, Chapter 7
Compile Method  Volume 4, Chapter 17
Compiling an English Query Application  Volume 4, Chapter 15
Compressed Snapshot Files  Volume 4, Chapter 5
Compute Scalar  Volume 2, Chapter 18
Concatenation  Volume 2, Chapter 18
Concurrency Architecture  Volume 1, Chapter 7
Conditional Expressions  Volume 3, Chapter 7
Conditional INSERT Trigger  Volume 2, Chapter 8
Configuration Option Specifications  Volume 1, Chapter 11
Configuring a Publication to Allow Copying  Volume 4, Chapter 5
Configuring a Publication to Allow Subscribers to Retrieve Snapshots Using FTP  Volume 4, Chapter 5
Configuring a Publisher or Distributor to Listen on TCP/IP  Volume 4, Chapter 5
Configuring a Subscription to Use FTP to Retrieve a Snapshot  Volume 4, Chapter 5
Configuring Analysis Servers  Volume 3, Chapter 5
Configuring Analysis Servers  Volume 3, Chapter 8
Configuring Replication  Volume 4, Chapter 5
Configuring Server Tasking  Volume 2, Chapter 21
Configuring Virtual Memory  Volume 2, Chapter 21
Connecting to the Distributor  Volume 4, Chapter 10
Constant Scan  Volume 2, Chapter 18
Constraints  Volume 1, Chapter 6
Constraints, Rules, Defaults, and Triggers  Volume 1, Chapter 6
Controlling Net-Libraries and Communications Addresses  Volume 1, Chapter 5
Converting Writeback Data to a Partition  Volume 3, Chapter 5
Copying a Subscription Database  Volume 4, Chapter 5
Copying and Pasting Objects  Volume 3, Chapter 5
Count Property  Volume 4, Chapter 17
CreateProject Method  Volume 4, Chapter 17
Creating a Calculated Member in a Virtual Cube  Volume 3, Chapter 5
Creating a Cell Within the Context of a Cube  Volume 3, Chapter 7
Creating a Data Warehouse  Volume 2, Chapter 13
Creating a Database  Volume 2, Chapter 3
Creating a Database Plan  Volume 2, Chapter 3
Creating a Mixed English Query Model  Volume 4, Chapter 15
Creating a Named Set in a Virtual Cube  Volume 3, Chapter 5
Creating a Partitioned View  Volume 2, Chapter 6
Creating a Removable Database  Volume 2, Chapter 3
Creating a Shared Dimension with the Editor  Volume 3, Chapter 5
Creating a Shared Dimension with the Wizard  Volume 3, Chapter 5
Creating a Stored Procedure  Volume 2, Chapter 7
Creating a Transformable Subscription Using Replication Wizards  Volume 4, Chapter 6
Creating a Trigger  Volume 2, Chapter 8
Creating a View  Volume 2, Chapter 6
Creating Actions  Volume 3, Chapter 5
Creating Actions in Regular Cubes  Volume 3, Chapter 5
Creating an Action in a Virtual Cube  Volume 3, Chapter 5
Creating an Analysis Services Processing Task  Volume 3, Chapter 5
Creating an English Query Model  Volume 4, Chapter 15
Creating an Index  Volume 2, Chapter 5
Creating an Indexed View  Volume 2, Chapter 6
Creating and Maintaining Actions in Virtual Cubes  Volume 3, Chapter 5
Creating and Maintaining Calculated Members in Virtual Cubes  Volume 3, Chapter 5
Creating and Maintaining Databases Overview  Volume 2, Part 2 Intro
Creating and Maintaining Named Sets in Virtual Cubes  Volume 3, Chapter 5
Creating and Maintaining Private Dimensions  Volume 3, Chapter 5
Creating and Modifying a Table  Volume 2, Chapter 4
Creating and Modifying CHECK Constraints  Volume 2, Chapter 4
Creating and Modifying DEFAULT Definitions  Volume 2, Chapter 4
Creating and Modifying FOREIGN KEY Constraints  Volume 2, Chapter 4
Creating and Modifying Identifier Columns  Volume 2, Chapter 4
Creating and Modifying PRIMARY KEY Constraints  Volume 2, Chapter 4
Creating and Modifying UNIQUE Constraints  Volume 2, Chapter 4
Creating and Using Data Warehouses Overview  Volume 2, Chapter 11
Creating and Using Property Values  Volume 3, Chapter 7
Creating and Using User-Defined Functions in MDX  Volume 3, Chapter 7
Creating Ascending and Descending Indexes  Volume 2, Chapter 5
Creating Calculated Cells  Volume 3, Chapter 5
Creating Calculated Cells in Regular Cubes  Volume 3, Chapter 5
Creating Calculated Cells in Virtual Cubes  Volume 3, Chapter 5
Creating Calculated Members  Volume 3, Chapter 5
Creating Calculated Members in Regular Cubes  Volume 3, Chapter 5
Creating CDATA Sections Using sql:use-cdata  Volume 1, Chapter 14
Creating Constant Elements Using sql:is-constant  Volume 1, Chapter 14
Creating Cube Roles  Volume 3, Chapter 5
Creating Cubes' Prerequisite Objects  Volume 3, Chapter 8
Creating Custom Member Formulas  Volume 3, Chapter 5
Creating Data Mining Models  Volume 3, Chapter 5
Creating Database Roles  Volume 3, Chapter 5
Creating Databases  Volume 3, Chapter 5
Creating Dimensions with Multiple Hierarchies  Volume 3, Chapter 5
Creating Filegroups  Volume 2, Chapter 3
Creating Indexes on Computed Columns  Volume 2, Chapter 5
Creating Indexes on Views  Volume 2, Chapter 5
Creating Member Groups  Volume 3, Chapter 5
Creating Member Properties  Volume 3, Chapter 5
Creating Mining Model Roles  Volume 3, Chapter 5
Creating Named Sets  Volume 3, Chapter 5
Creating Named Sets in Regular Cubes  Volume 3, Chapter 5
Creating OLAP Data Mining Models  Volume 3, Chapter 5
Creating Partitions  Volume 3, Chapter 5
Creating Predictions Using Data Transformation Services  Volume 3, Chapter 5
Creating Prerequisite Objects for Cubes  Volume 3, Chapter 5
Creating Relational Data Mining Models  Volume 3, Chapter 5
Creating Relationships in the OLAP Project Wizard  Volume 4, Chapter 16
Creating Security Roles  Volume 3, Chapter 5
Creating Security Roles  Volume 3, Chapter 8
Creating Shared Dimensions  Volume 3, Chapter 5
Creating the Data Preparation Area  Volume 2, Chapter 13
Creating the Data Warehouse Database  Volume 2, Chapter 13
Creating the nwind Virtual Directory  Volume 1, Chapter 12
Creating the nwind Virtual Directory Using the Object Model  Volume 1, Chapter 12
Creating User-Defined Data Types  Volume 2, Chapter 4
Creating Valid ID, IDREF, and IDREFS Type Attributes Using sql:id-prefix  Volume 1, Chapter 14
Creating Virtual Dimensions  Volume 3, Chapter 5
Creating XML Views Using Annotated XDR Schemas  Volume 1, Chapter 14
Cross Join  Volume 2, Chapter 18
Cube Enhancements  Volume 3, Chapter 1
Cube Processing  Volume 3, Chapter 3
Cube Roles  Volume 3, Chapter 3
Cube Security  Volume 3, Chapter 3
Cube Storage  Volume 3, Chapter 3
Cube Structure  Volume 3, Chapter 3
Cube Varieties  Volume 3, Chapter 3
Cubes  Volume 3, Chapter 3
Cursor Architecture  Volume 1, Chapter 7
Cursor Logical and Physical Operators  Volume 2, Chapter 18
Custom Applications  Volume 2, Chapter 14
Custom Member Properties  Volume 3, Chapter 7
Custom Rollup Formulas and Custom Member Formulas  Volume 3, Chapter 3
Custom Rollup Operators  Volume 3, Chapter 3
Custom Rules in Cell Security  Volume 3, Chapter 3
Custom Rules in Dimension Security  Volume 3, Chapter 3
Custom Stored Procedure Conflict Resolver  Volume 4, Chapter 3

D
Data Import/Export Architecture  Volume 1, Chapter 8
Data Integrity  Volume 2, Chapter 3
Data Integrity Validation  Volume 1, Chapter 8
Data Marts  Volume 2, Chapter 12
Data Members  Volume 3, Chapter 3
Data Mining Algorithms  Volume 3, Chapter 3
Data Mining Column Content Types  Volume 3, Chapter 3
Data Mining Column Data Types  Volume 3, Chapter 3
Data Mining Column Storage  Volume 3, Chapter 3
Data Mining Columns  Volume 3, Chapter 3
Data Mining Dimensions  Volume 3, Chapter 3
Data Mining Enhancements  Volume 3, Chapter 1
Data Mining Model Nodes  Volume 3, Chapter 3
Data Mining Model Storage  Volume 3, Chapter 3
Data Mining Model Structure  Volume 3, Chapter 3
Data Mining Models  Volume 3, Chapter 3
Data Needs and Characteristics  Volume 4, Chapter 2
Data Placement Using Filegroups  Volume 2, Chapter 17
Data Preparation Area  Volume 2, Chapter 12
Data Security  Volume 2, Chapter 3
Data Slice  Volume 3, Chapter 5
Data Sources  Volume 2, Chapter 12
Data Sources  Volume 3, Chapter 3
Data Transformation Services API  Volume 1, Chapter 10
Data Type Coercions  Volume 1, Chapter 14
Data Type Mapping to Jet-SQL 4.0 for Merge Replication  Volume 4, Chapter 9
Data Types and Table Structures  Volume 1, Chapter 6
Data Warehousing  Volume 1, Chapter 4
Data Warehousing and OLAP  Volume 3, Chapter 4
Data Warehousing and Online Analytical Processing  Volume 1, Chapter 9
Database Applications and Servers  Volume 1, Chapter 5
Database Architecture  Volume 1, Chapter 6
Database Backup and Restore  Volume 1, Chapter 8
Database Design  Volume 2, Chapter 17
Database Design Considerations  Volume 2, Chapter 3
Database Design Considerations: Data Types  Volume 2, Chapter 17
Database Engine Components  Volume 1, Chapter 7
Database Maintenance Plan Wizard  Volume 2, Chapter 3
Database Performance  Volume 2, Chapter 3
Database Roles  Volume 3, Chapter 3
Database Security  Volume 3, Chapter 3
Database, Cube, and Mining Model Roles  Volume 3, Chapter 3
Databases  Volume 2, Chapter 3
Databases  Volume 3, Chapter 3
Date and Time Data  Volume 2, Chapter 4
DBCC* statements  Volume 5, Chapter 8
DB-Library API  Volume 1, Chapter 10
DBMSType Property (QueryCmd Object)  Volume 4, Chapter 17
DBMSType Property (Session Object)  Volume 4, Chapter 17
DBMSVersion Property  Volume 4, Chapter 17
DDL and Stored Procedures  Volume 1, Chapter 8
DEFAULT Definitions  Volume 2, Chapter 4
Default Filegroups  Volume 2, Chapter 3
Default Mapping of XDR Elements and Attributes to Tables and Columns  Volume 1, Chapter 14
Default Resolver and Custom Resolvers  Volume 4, Chapter 3
Defaults  Volume 1, Chapter 6
Deferred Name Resolution and Compilation  Volume 2, Chapter 7
Defining a Horizontal Partition  Volume 4, Chapter 6
Defining a Vertical Partition  Volume 4, Chapter 6
Defining Custom Rules for Cell Security  Volume 3, Chapter 5
Defining Custom Rules for Dimension Security  Volume 3, Chapter 5
Defining Entities in an English Query Model  Volume 4, Chapter 15
Defining Relationship Phrasings  Volume 4, Chapter 15
Degree of Parallelism  Volume 1, Chapter 7
Delete  Volume 2, Chapter 18
Deleted Scan  Volume 2, Chapter 18
Deleting a Database  Volume 2, Chapter 3
Deleting a Stored Procedure  Volume 2, Chapter 7
Deleting a Table  Volume 2, Chapter 4
Deleting a Trigger  Volume 2, Chapter 8
Deleting a View  Volume 2, Chapter 6
Deleting an Index  Volume 2, Chapter 5
Deleting Writeback Data and Write-Disabling a Cube  Volume 3, Chapter 5
Dependent Dimensions  Volume 3, Chapter 3
Deploying an English Query Application  Volume 4, Chapter 15
Description Property (ErrorResponse Object)  Volume 4, Chapter 17
Description Property (QBEntity Object, QBRelationship Object)  Volume 4, Chapter 17
Description Property (QBTemplateObject)  Volume 4, Chapter 17
Designing a Data Warehouse  Volume 2, Chapter 13
Designing a Replication Topology  Volume 4, Chapter 2
Designing an Index  Volume 2, Chapter 5
Designing an Indexed View  Volume 2, Chapter 6
Designing Federated Database Servers  Volume 2, Chapter 16
Designing Federated Database Servers for High Availability  Volume 2, Chapter 16
Designing INSTEAD OF Triggers  Volume 2, Chapter 8
Designing Partitions  Volume 2, Chapter 16
Designing Storage Options and Aggregations  Volume 3, Chapter 5
Designing Tables  Volume 2, Chapter 4
Designing Triggers  Volume 2, Chapter 8
Deterministic and Nondeterministic Functions  Volume 2, Chapter 9
Developing a Drive Performance Strategy  Volume 2, Chapter 17
Developing and Deploying English Query Applications  Volume 4, Chapter 15
Different Fact Tables for Partitions  Volume 3, Chapter 5
Differential Backup and Restore  Volume 1, Chapter 8
Dimension Characteristics  Volume 3, Chapter 3
Dimension Enhancements  Volume 3, Chapter 1
Dimension Filters  Volume 3, Chapter 6
Dimension Hierarchies  Volume 3, Chapter 3
Dimension Processing  Volume 3, Chapter 3
Dimension Security  Volume 3, Chapter 3
Dimension Storage Modes  Volume 3, Chapter 3
Dimension Structure  Volume 3, Chapter 3
Dimension Tables  Volume 2, Chapter 13
Dimension Varieties  Volume 3, Chapter 3
Dimensions  Volume 3, Chapter 3
Disabling Publishing and Distribution  Volume 4, Chapter 5
Display Formats  Volume 3, Chapter 3
Displaying Database and Transaction Log Space  Volume 2, Chapter 3
DisplayRows Property  Volume 4, Chapter 17
DisplayToUser Property  Volume 4, Chapter 17
Distinct  Volume 2, Chapter 18
Distinct Sort  Volume 2, Chapter 18
Distribute Streams  Volume 2, Chapter 18
Distributed Partitioned Cubes  Volume 3, Chapter 3
Distributed Query Architecture  Volume 1, Chapter 7
Distributed Transactions Architecture  Volume 1, Chapter 7
Distributed Update Factors  Volume 4, Chapter 2
Distributing Data to Data Marts  Volume 2, Chapter 13
Distribution Agent Profile  Volume 4, Chapter 8
Distribution Agents  Volume 4, Chapter 8
Distribution Statistics  Volume 1, Chapter 6
Documenting and Scripting Databases  Volume 2, Chapter 3
DomainCmd Object  Volume 4, Chapter 17
DomainInfo Object  Volume 4, Chapter 17
DomainInfo Property  Volume 4, Chapter 17
Drillthrough Filters  Volume 3, Chapter 6
DTS Package Details  Volume 4, Chapter 6
Dynamic Filters  Volume 4, Chapter 6
Dynamic Snapshots  Volume 4, Chapter 6
Dynamically Managing Memory Between Multiple Instances  Volume 1, Chapter 7
Dynamically Managing Memory on Windows 95 and Windows 98  Volume 1, Chapter 7
Dynamically Managing Memory on Windows NT and Windows 2000  Volume 1, Chapter 7

E
Eager Spool  Volume 2, Chapter 18
Ease of Installation, Deployment, and Use  Volume 1, Chapter 4
Ease of Use  Volume 3, Chapter 3
Editing a Calculated Member in a Virtual Cube  Volume 3, Chapter 5
Editing a Named Set in a Virtual Cube  Volume 3, Chapter 5
Editing an Action in a Virtual Cube  Volume 3, Chapter 5
Editing Data Mining Models  Volume 3, Chapter 5
Editing OLAP Data Mining Models  Volume 3, Chapter 5
Editing Relational Data Mining Models  Volume 3, Chapter 5
Editions of SQL Server 2000  Volume 1, Chapter 11
Effective MDX  Volume 3, Chapter 7
Effects of min and max server memory  Volume 1, Chapter 7
Effects of Stored Procedures on Application Performance  Volume 2, Chapter 19
Effects of Transactions and Batches on Application Performance  Volume 2, Chapter 19
Enabling Analysis Services for an English Query Model  Volume 4, Chapter 15
Enabling Full-Text Search for an English Query Model  Volume 4, Chapter 15
Enabling Others to Issue Full-Text Queries  Volume 2, Chapter 10
Enabling SQL for an English Query Model  Volume 4, Chapter 15
EndCommands Collection  Volume 4, Chapter 17
End-User Analysis  Volume 2, Chapter 12
End-User Security  Volume 3, Chapter 3
Enforcing Business Rules with Triggers  Volume 2, Chapter 8
Engine Collections Methods Summary  Volume 4, Chapter 17
Engine Collections Properties Summary  Volume 4, Chapter 17
Engine Collections Summary  Volume 4, Chapter 17
Engine Methods Summary  Volume 4, Chapter 17
Engine Object Model  Volume 4, Chapter 17
Engine Object Model Diagram  Volume 4, Chapter 17
Engine Objects Summary  Volume 4, Chapter 17
Engine Properties Summary  Volume 4, Chapter 17
English Query  Volume 2, Chapter 14
English Query Fundamentals  Volume 4, Chapter 14
English Query Overview  Volume 4, Chapter 13
Enhancing Cubes with Optional Features  Volume 3, Chapter 5
Enhancing Cubes with Optional Features  Volume 3, Chapter 8
Enhancing Dimensions  Volume 3, Chapter 8
Enhancing Dimensions with Optional Features  Volume 3, Chapter 5
Enhancing Merge Replication Performance  Volume 4, Chapter 11
Enhancing Replication Performance  Volume 4, Chapter 11
Enhancing Snapshot and Transactional Replication Performance  Volume 4, Chapter 11
Enhancing Snapshot Replication Performance  Volume 4, Chapter 11
Enhancing Transactional Replication Performance  Volume 4, Chapter 11
Enterprise-Level Database Features  Volume 1, Chapter 4
Entities as Roles  Volume 4, Chapter 15
Entities Collection  Volume 4, Chapter 17
Entity Defaults  Volume 4, Chapter 15
Entity Name Synonyms  Volume 4, Chapter 15
EQError Object  Volume 4, Chapter 17
EQModel Object  Volume 4, Chapter 17
ErrorCode Property  Volume 4, Chapter 17
ErrorResponse Object  Volume 4, Chapter 17
Errors Property  Volume 4, Chapter 17
Establishing Cube Context  Volume 3, Chapter 7
Estimating the Size of a Database  Volume 2, Chapter 3
Estimating the Size of a Table  Volume 2, Chapter 3
Estimating the Size of a Table with a Clustered Index  Volume 2, Chapter 3
Estimating the Size of a Table Without a Clustered Index  Volume 2, Chapter 3
Evaluating the Replication Environment  Volume 4, Chapter 2
Excel Functions  Volume 3, Chapter 7
Excluding Schema Elements from the Resulting XML Document Using sql:map-field  Volume 1, Chapter 14
Executing a Stored Procedure  Volume 2, Chapter 7
Executing Scripts Before and After the Snapshot is Applied  Volume 4, Chapter 5
Executing SQL Queries Using Templates  Volume 1, Chapter 13
Executing SQL Statements Using HTTP  Volume 1, Chapter 13
Executing Stored Procedures Using HTTP  Volume 1, Chapter 13
Executing Template Files Using HTTP  Volume 1, Chapter 13
Executing XPath Queries Using HTTP  Volume 1, Chapter 13
Executing XPath Queries Using Templates  Volume 1, Chapter 13
Execution Plan Caching and Reuse  Volume 1, Chapter 7
Expanding a Database  Volume 2, Chapter 3
Expanding an English Query Model  Volume 4, Chapter 15
Explicit Mapping of XDR Elements and Attributes to Tables and Columns  Volume 1, Chapter 14
Exploring Snapshots  Volume 4, Chapter 5
Expressions and Computed Columns in INSTEAD OF Triggers  Volume 2, Chapter 8
Extended Stored Procedure API  Volume 1, Chapter 10
Extended Stored Procedure Architecture  Volume 1, Chapter 7
Extended Stored Procedures  Volume 2, Chapter 7
Extracting Data from Operational Systems  Volume 2, Chapter 13

F
Fact Table Considerations When Merging Partitions  Volume 3, Chapter 5
Fact Tables  Volume 2, Chapter 13
Failover Clustering Architecture  Volume 1, Chapter 5
FallbackDBMSType Property  Volume 4, Chapter 17
FallbackDBMSVersion Property  Volume 4, Chapter 17
Features of SQL Server 2000  Volume 1, Chapter 4
Features Supported by the Editions of SQL Server 2000  Volume 1, Chapter 11
Federated SQL Server 2000 Servers  Volume 1, Chapter 5
FetchDatabaseStructure Method  Volume 4, Chapter 17
FieldCount Property  Volume 4, Chapter 17
Fields Property (Parameter Object)  Volume 4, Chapter 17
File and Filegroup Backup and Restore  Volume 1, Chapter 8
File Systems  Volume 2, Chapter 17
FileName Property  Volume 4, Chapter 17
Files and Filegroups  Volume 2, Chapter 3
Fill Factor  Volume 2, Chapter 5
Filter  Volume 2, Chapter 18
Filtering Published Data  Volume 4, Chapter 6
Filtering Supported File Types  Volume 2, Chapter 10
Filtering Values Using sql:limit-field and sql:limit-value  Volume 1, Chapter 14
FindObject Method  Volume 4, Chapter 17
FindTemplates Method  Volume 4, Chapter 17
Flexible Data Model  Volume 3, Chapter 3
Flow Distinct  Volume 2, Chapter 18
FORE_COLOR and BACK_COLOR Contents  Volume 3, Chapter 7
FOREIGN KEY Constraints  Volume 2, Chapter 4
FORMAT_STRING Contents  Volume 3, Chapter 7
Freeing and Writing Buffer Pages  Volume 1, Chapter 7
Full Outer Join  Volume 2, Chapter 18
FullName Property  Volume 4, Chapter 17
Full-Text Catalogs and Indexes  Volume 1, Chapter 6
Full-Text Indexes  Volume 2, Chapter 10
Full-Text Indexing Support  Volume 1, Chapter 7
Full-Text Query Architecture  Volume 1, Chapter 7
Full-Text Querying Support  Volume 1, Chapter 7
Fundamentals of SQL Server 2000 Architecture  Volume 1, Chapter 3
Fuzzy Backup and Restore Operations  Volume 1, Chapter 8

G
Gather Streams  Volume 2, Chapter 18
Generating the Initial Snapshot  Volume 4, Chapter 5
GetCommonRelationships Method  Volume 4, Chapter 17
GetExamples Method  Volume 4, Chapter 17
Getting Information About a View  Volume 2, Chapter 6
Graphical Tools  Volume 1, Chapter 8
Graphically Displaying the Execution Plan Using SQL Query Analyzer  Volume 2, Chapter 18
Grouped Phrasings Examples  Volume 4, Chapter 15
Groups  Volume 1, Chapter 6
Guidelines for Using the FOR XML Clause  Volume 1, Chapter 16
Guidelines for Using XPath Queries  Volume 1, Chapter 15

H
Handling Agent Errors  Volume 4, Chapter 8
Hardware and Software Requirements for Installing Analysis Services  Volume 3, Chapter 2
Hash Match  Volume 2, Chapter 18
Hash Match Root  Volume 2, Chapter 18
Hash Match Team  Volume 2, Chapter 18
Heap Structures  Volume 1, Chapter 6
HelpCmd Object  Volume 4, Chapter 17
HelpText Property (HelpCmd Object)  Volume 4, Chapter 17
HelpText Property (QBEntity Object, QBRelationship Object)  Volume 4, Chapter 17
HelpType Property  Volume 4, Chapter 17
Heterogeneous Publishers  Volume 4, Chapter 9
Heterogeneous Subscribers  Volume 4, Chapter 9
How Alternate Synchronization Partners Works  Volume 4, Chapter 6
How Immediate Updating Works  Volume 4, Chapter 6
How Merge Replication Works  Volume 4, Chapter 3
How Queued Updating Works  Volume 4, Chapter 6
How Replication Works  Volume 4, Chapter 1
How Snapshot Replication Works  Volume 4, Chapter 3
How To  Volume 3, Chapter 8
How To  Volume 4, Chapter 18
How to add a dictionary entry  Volume 4, Chapter 18
How to add a field to a table  Volume 4, Chapter 18
How to add a hierarchy to an existing dimension  Volume 3, Chapter 8
How to add a join  Volume 4, Chapter 18
How to add a linked Analysis server using SQL Server Enterprise Manager  Volume 3, Chapter 8
How to add a module  Volume 4, Chapter 18
How to add a multiple-column measure to a cube  Volume 3, Chapter 8
How to add a new or existing regression test file to a project  Volume 4, Chapter 18
How to add a new project to a solution  Volume 4, Chapter 18
How to add a phrasing to a command relationship  Volume 4, Chapter 18
How to add a relationship  Volume 4, Chapter 18
How to add a role to a data mining model  Volume 3, Chapter 8
How to add a table  Volume 4, Chapter 18
How to add an Analysis Services (formerly OLAP) cube to a model  Volume 4, Chapter 18
How to add an entity to a relationship  Volume 4, Chapter 18
How to add an existing project to a solution  Volume 4, Chapter 18
How to add entities and relationships using the Create Semantics command  Volume 4, Chapter 18
How to add or change a SQL connection  Volume 4, Chapter 18
How to add or change an Analysis Services (formerly OLAP) connection  Volume 4, Chapter 18
How to add phrasings to a relationship  Volume 4, Chapter 18
How to add tables and views from a SQL data source  Volume 4, Chapter 18
How to add time and location options to a relationship  Volume 4, Chapter 18
How to archive an Analysis Services database using Analysis Manager  Volume 3, Chapter 8
How to archive an Analysis Services database using the msmdarch command  Volume 3, Chapter 8
How to associate English Data values with a relationship  Volume 4, Chapter 18
How to browse a private dimension  Volume 3, Chapter 8
How to browse a shared dimension  Volume 3, Chapter 8
How to browse sample data in Cube Editor  Volume 3, Chapter 8
How to browse writeback data for a cube  Volume 3, Chapter 8
How to build a cube with Cube Editor  Volume 3, Chapter 8
How to build an application  Volume 4, Chapter 18
How to change the table options for a relationship  Volume 4, Chapter 18
How to change the temporary file folder used by Analysis Services  Volume 3, Chapter 8
How to configure Analysis Services for the Web  Volume 3, Chapter 8
How to convert a cube's writeback data to a partition and write-disable the cube  Volume 3, Chapter 8
How to copy and paste an object  Volume 3, Chapter 8
How to create a calculated member in a regular cube  Volume 3, Chapter 8
How to create a calculated member in a virtual cube  Volume 3, Chapter 8
How to create a command relationship  Volume 4, Chapter 18
How to create a cube role, change its default values, and specify cell security  Volume 3, Chapter 8
How to create a custom member formula in a write-enabled dimension  Volume 3, Chapter 8
How to create a custom rollup operator for a private dimension  Volume 3, Chapter 8
How to create a custom rollup operator for a shared dimension  Volume 3, Chapter 8
How to create a custom rule for cell security  Volume 3, Chapter 8
How to create a custom rule for dimension security in a cube role  Volume 3, Chapter 8
How to create a custom rule for dimension security in a database role  Volume 3, Chapter 8
How to create a database  Volume 3, Chapter 8
How to create a database role  Volume 3, Chapter 8
How to create a dimension with multiple hierarchies in Dimension Editor  Volume 3, Chapter 8
How to create a dimension with multiple hierarchies in the Dimension Wizard  Volume 3, Chapter 8
How to create a linked cube  Volume 3, Chapter 8
How to create a member property in a shared dimension  Volume 3, Chapter 8
How to create a mining model role and change its default values  Volume 3, Chapter 8
How to create a mixed model  Volume 4, Chapter 18
How to create a named set in a regular cube  Volume 3, Chapter 8
How to create a named set in a virtual cube  Volume 3, Chapter 8
How to create a new project  Volume 4, Chapter 18
How to create a new project using the SQL Project wizard  Volume 4, Chapter 18
How to create a private dimension  Volume 3, Chapter 8
How to create a project using the OLAP Project wizard  Volume 4, Chapter 18
How to create a Relational Data Mining Prediction Query task  Volume 3, Chapter 8
How to create a relationship using the Canvas pane  Volume 4, Chapter 18
How to create a shared dimension using Dimension Editor  Volume 3, Chapter 8
How to create a shared dimension using the Dimension Wizard  Volume 3, Chapter 8
How to create a virtual dimension based on columns  Volume 3, Chapter 8
How to create a virtual dimension based on member properties  Volume 3, Chapter 8
How to create an action in a regular cube  Volume 3, Chapter 8
How to create an action in a virtual cube  Volume 3, Chapter 8
How to create an Analysis Services Processing task  Volume 3, Chapter 8
How to create an entity  Volume 4, Chapter 18
How to create and modify project properties  Volume 4, Chapter 18
How to create calculated cells  Volume 3, Chapter 8
How to create member groups  Volume 3, Chapter 8
How to create or select a column to store custom member formulas  Volume 3, Chapter 8
How to create relationships from the Model Test Window  Volume 4, Chapter 18
How to create relationships using the Create Relationships command  Volume 4, Chapter 18
How to create time and location options for command relationships  Volume 4, Chapter 18
How to delete a command relationship  Volume 4, Chapter 18
How to delete a dictionary entry  Volume 4, Chapter 18
How to delete a field from a model  Volume 4, Chapter 18
How to delete a join  Volume 4, Chapter 18
How to delete a relationship  Volume 4, Chapter 18
How to delete a table  Volume 4, Chapter 18
How to delete an entity  Volume 4, Chapter 18
How to delete an entity from a relationship  Volume 4, Chapter 18
How to delete writeback data for a cube and write-disable it  Volume 3, Chapter 8
How to deploy an application to the Web  Volume 4, Chapter 18
How to edit a calculated cells definition  Volume 3, Chapter 8
How to edit a calculated member in a virtual cube  Volume 3, Chapter 8
How to edit a command relationship  Volume 4, Chapter 18
How to edit a dictionary entry  Volume 4, Chapter 18
How to edit a field in a model  Volume 4, Chapter 18
How to edit a join  Volume 4, Chapter 18
How to edit a named set in a virtual cube  Volume 3, Chapter 8
How to edit a regression test file  Volume 4, Chapter 18
How to edit a table  Volume 4, Chapter 18
How to edit an action in a virtual cube  Volume 3, Chapter 8
How to edit an Analysis Services (formerly OLAP) cube  Volume 4, Chapter 18
How to edit an entity  Volume 4, Chapter 18
How to edit Analysis Services (formerly OLAP) measures  Volume 4, Chapter 18
How to edit Analysis Services (formerly OLAP) properties  Volume 4, Chapter 18
How to edit Analysis Services levels  Volume 4, Chapter 18
How to edit the entity's role in a relationship  Volume 4, Chapter 18
How to enable Analysis Services (formerly OLAP)  Volume 4, Chapter 18
How to enable full-text searching for a field  Volume 4, Chapter 18
How to import a calculated member into a virtual cube  Volume 3, Chapter 8
How to import a named set into a virtual cube  Volume 3, Chapter 8
How to import an action into a virtual cube  Volume 3, Chapter 8
How to import calculated cells into a virtual cube  Volume 3, Chapter 8
How to incrementally update a cube  Volume 3, Chapter 8
How to incrementally update a shared dimension  Volume 3, Chapter 8
How to manually map OLAP objects to the underlying SQL database objects  Volume 4, Chapter 18
How to merge two partitions  Volume 3, Chapter 8
How to modify a relationship  Volume 4, Chapter 18
How to modify the data source in a project  Volume 4, Chapter 18
How to process a cube  Volume 3, Chapter 8
How to process a data mining model  Volume 3, Chapter 8
How to process a linked cube  Volume 3, Chapter 8
How to process a partition  Volume 3, Chapter 8
How to process a virtual cube  Volume 3, Chapter 8
How to rebuild the structure of a shared dimension  Volume 3, Chapter 8
How to refresh all tables in a project  Volume 4, Chapter 18
How to refresh data in a cube  Volume 3, Chapter 8
How to register an Analysis server  Volume 3, Chapter 8
How to remove a database from a project  Volume 4, Chapter 18
How to remove a module  Volume 4, Chapter 18
How to remove a project from the solution  Volume 4, Chapter 18
How to remove a regression test file  Volume 4, Chapter 18
How to remove an Analysis Services (formerly OLAP) cube  Volume 4, Chapter 18
How to rename a calculated member  Volume 3, Chapter 8
How to rename a regression test file  Volume 4, Chapter 18
How to restore an Analysis Services database using Analysis Manager  Volume 3, Chapter 8
How to restore an Analysis Services database using the msmdarch command  Volume 3, Chapter 8
How to save model test information to a regression test file  Volume 4, Chapter 18
How to save the regression output to a regression test file  Volume 4, Chapter 18
How to set the Sample Data option  Volume 4, Chapter 18
How to specify a data source  Volume 3, Chapter 8
How to specify a data source for a linked cube  Volume 3, Chapter 8
How to specify drillthrough options for a linked cube  Volume 3, Chapter 8
How to specify drillthrough options for a partition  Volume 3, Chapter 8
How to specify drillthrough options for a regular cube  Volume 3, Chapter 8
How to specify drillthrough options for a virtual cube  Volume 3, Chapter 8
How to start Mining Model Role Manager  Volume 3, Chapter 8
How to start OLAP Mining Model Editor  Volume 3, Chapter 8
How to start Relational Mining Model Editor  Volume 3, Chapter 8
How to start the Cube Wizard  Volume 3, Chapter 8
How to start the Migrate Repository Wizard  Volume 3, Chapter 8
How to start the Mining Model Wizard  Volume 3, Chapter 8
How to start the Partition Wizard  Volume 3, Chapter 8
How to start the Storage Design Wizard  Volume 3, Chapter 8
How to start the Usage Analysis Wizard  Volume 3, Chapter 8
How to start the Usage-Based Optimization Wizard  Volume 3, Chapter 8
How to start the Virtual Cube Wizard  Volume 3, Chapter 8
How to test a model  Volume 4, Chapter 18
How to test an action  Volume 3, Chapter 8
How to view an SQL statement  Volume 3, Chapter 8
How to view the differences between the current regression test file and the regression output file  Volume 4, Chapter 18
How to view the output of a regression test created using the Run Regression command  Volume 4, Chapter 18
How to write-enable a cube  Volume 3, Chapter 8
How Transactional Replication Works  Volume 4, Chapter 3
How Transforming Published Data Works  Volume 4, Chapter 6