MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

b-trees

       clustered indexes  

backing up

       backup and disaster recovery  

       using filegroups   2nd  

base date  

batch size  

batches   2nd   3rd   4th   5th  

BCP (Bulk Copy Program)   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  

BCP utility  

BEGIN

       statement blocks   2nd   3rd  

BEGIN TRANSACTION   2nd   3rd  

BEGIN TRANSACTION command  

benefits.   [See advantages]

BETWEEN   2nd   3rd  

bigint data type   2nd   3rd  

BINARY BASE64 option (FOR XML operator)  

binary data type  

binary data types   2nd  

binary relationships  

BINARY_CHECKSUM() function  

bitwise operators   2nd  

Bookmark Lookup operation  

Books Online   2nd   3rd  

       Accessing and Changing Relational Data book  

       Administering SQL Server book  

       Analysis Services book  

       Building SQL Server Applications book  

       Contents tab  

       Creating and Maintaining Databases book  

       Creating and Using Data Warehouses book  

       Data Transformation Services book  

       English Query book  

       Getting Started book  

       Glossary  

       How-To book  

       Index tab  

       Installing SQL Server book  

       Meta Data Services book  

       Optimizing Database Performance book  

       Replication book  

       Search tab  

       Transact-SQL reference  

       Troubleshooting book  

       Using SQL Server Tool book  

       What's New? book  

       XML and Internet Support book  

broken ownership chains   2nd   3rd   4th   5th  

built-in functions   2nd  

Bulk Copy program  

Bulk Copy Program (BCP)   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  

BULK INSERT statement   2nd   3rd  

BULK LOGGED mode (database recovery)  

Bulk-Logged recovery model  

BULK_LOGGED database configuration option  

business rules

       data integrity  

Категории