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]
RAID (Redundant Array of Independent/Inexpensive Disks) 2nd levels software versus hardware RAISERROR 2nd 3rd RAISERROR() command raising errors 2nd user -defined errors RAW option (FOR XML operator) 2nd RDBMS (Relational Database Management System) RDBMS (relational database management systems) Read Committed READ ONLY 2nd Read Uncommitted READ_ONLY database configuration option READ_WRITE database configuration option reading execution plans Query Analyzer 2nd 3rd rebuilding indexes 2nd with DBCC DBREINDEX RECOMPILE 2nd recompiling procedures RECONFIGURE command records defined recoverability backup and disaster recovery operating system service properties 2nd 3rd recovery models 2nd 3rd 4th standby servers system and data RECOVERY FULL database configuration option recovery models Bulk-Logged Full Simple recursive triggers direct recursion 2nd 3rd 4th indirect recursion 2nd RECURSIVE_TRIGGERS database configuration option reducing lock contention 2nd redundancy Redundant Array of Independent/Inexpensive Disks. [See RAID] referential integrity 2nd 3rd 4th 5th 6th triggers enforcing 2nd 3rd 4th 5th relational database engines running multiple instances Relational Database Management System (RDBMS) relational database management systems. [See RDBMS] relational databases 2nd relationships 2nd 3rd defining 2nd 3rd 4th implementing 2nd 3rd many-to-many many-to-many relationships one-to-many one-to-many relationships one-to-one one-to-one relationships remote agent activation 2nd removing views 2nd 3rd renaming triggers 2nd 3rd views 2nd Repeatable Read replays of traces performing 2nd replays. [See also playing back] replication 2nd 3rd 4th advantages of 2nd agents 2nd Distribution agent Log Reader agent 2nd Merge agent 2nd Queue Reader agent Snapshot agent 2nd configurations central publisher, multiple subscribers 2nd 3rd multiple publishers, multiple subscribers 2nd 3rd multiple publishers, single subscriber 2nd single publisher, remote distributor 2nd confirming 2nd enabling 2nd heterogeneous interoperability 2nd latency 2nd merge replication 2nd 3rd how it works 2nd 3rd Publisher/Subscriber metaphor 2nd articles Distributor partitioning 2nd Publisher Subscriber subscriptions site autonomy snapshot replication 2nd 3rd changing snapshot lcoation 2nd how it works 2nd network considerations transactional consistency 2nd transactional replication 2nd 3rd filtering how it works 2nd 3rd 4th types of 2nd reporting data. [See grouping data] requirements certification for indexed views 2nd for playback 2nd 3rd 4th 5th hardware requirements for SQL Server 2nd requirements (of SQL Server 2000) 2nd hardware resources 2nd RESTRICTED_USER database configuration option restrictions on user-defined functions 2nd results of SQL Profiler 2nd retake policy for exams 2nd retrieving data. [See data retrieval] RETURN statement 2nd 3rd return values CURSOR STATUS passing back to stored procedures 2nd returning parameters to user-defined functions 2nd 3rd TOP rows 2nd 3rd returns as cursors RFFlow database design software RIGHT OUTER JOIN statement 2nd 3rd 4th roles 2nd application roles fixed roles ROLLBACK TRANSACTION 2nd ROLLUP operator 2nd 3rd versus COMPUTE and COMPUTE BY operators 2nd root nodes clustered indexes rows deleting through views 2nd 3rd 4th inserting through views 2nd 3rd 4th 5th selecting in views selecting based on null values 2nd TOP returning 2nd 3rd updating through views 2nd 3rd 4th rules data integrity data modification constraining for cursors
|