Index R

[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