MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition

Index

[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]

Bachman, Charles

Back Office integration 2nd

BACKUP statement

     moving data with 2nd

batches 2nd

     rules 2nd

     separating

BCP (Bulk Copy Program) 2nd 3rd 4th 5th

BEGIN TRANSACTION statement 2nd 3rd

BEGIN...END statement 2nd

BETWEEN keyword

bigint data type

binary data type

binary data types 2nd

binding

     schema binding 2nd 3rd 4th

bitwise operators

blocks

     BEGIN...END statement 2nd

Books Online 2nd

BREAK statement

broken ownership chains, troubleshooting 2nd 3rd

Bulk Copy Program [See BCP]

Bulk Copy Program (BCP)

BULK INSERT statement

business system design 2nd

     automation 2nd 3rd 4th

         alerts 2nd 3rd 4th 5th 6th

         jobs 2nd

         operators 2nd

     distributed data 2nd

         linked servers 2nd 3rd 4th

         OLE-DB 2nd

         OPENQUERY function

         OPENROWSET function 2nd 3rd

         remote servers 2nd

     exam prep questions 2nd 3rd 4th 5th

     Internet application architecture 2nd

     one-tier systems 2nd

     replication 2nd

         merge replication 2nd

         snapshot replication 2nd

         transactional replication

     SQL Server Back Office integration 2nd

     third-party database interactions 2nd

     three- or more tier systems 2nd

     two-tier systems 2nd

     very large database applications 2nd