R

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]

RAID (redundant array of independent/inexpensive disks) 2nd
RAND() function
Read Committed isolation level
Read Uncommitted isolation level
READ_ONLY cursors
READ_ONLY option (databases)
READ_WRITE option (databases)
READCOMMITTED hint
readiness for CISA exam 2nd
reading
     query execution plans 2nd 3rd 4th 5th
READPAST hint
READUNCOMMITTED hint
rebuilding
     indexes 2nd 3rd 4th
recompiling
     stored procedures 2nd
Reconfigure option (server properties) 2nd
records
     definition of
recovery
    database options
         RECOVERY BULK_LOGGED
         RECOVERY FULL
         RECOVERY SIMPLE
         TORN_PAGE_DETECTION
RECOVERY BULK_LOGGED option (databases)
RECOVERY FULL option (databases)
Recovery Interval option (server properties)
RECOVERY SIMPLE option (databases)
RECURSIVE_TRIGGERS option (databases)
redundant array of independent/inexpensive disks (RAID) 2nd
referential integrity
relational databases [See databases]
relationships 2nd 3rd 4th
     cardinality
     definition of
     identifying 2nd
     many-to-many 2nd 3rd 4th 5th
     one-to-many 2nd 3rd 4th
     one-to-one 2nd 3rd
Remote Access option (server properties)
Remote Login Timeout option (server properties)
Remote Proc Trans option (server properties)
Remote Query Timeout option (server properties)
remote servers 2nd 3rd
renaming
     triggers
Repeatable Read isolation level
REPEATABLEREAD hint
REPLICATE() function
replication 2nd 3rd 4th
     advantages of 2nd
     articles
     central Publisher, multiple Subscribers 2nd
     data distribution 2nd
     Distributors
     latency 2nd
     merge replication 2nd 3rd 4th
     multiple Publishers, multiple Subscribers 2nd
     multiple Publishers, single Subscriber
     publications
     Publishers
     single Publisher, single Subscriber 2nd
     site autonomy 2nd
     snapshot replication 2nd 3rd 4th
     Subscribers
     transactional consistency 2nd
     transactional replication 2nd 3rd
RESTORE statement
     moving data with 2nd
RESTRICTED_USER option (databases)
resultsets
REVERSE() function
REVOKE statement 2nd
revoking
     object permissions 2nd
roles
     definition of
     server roles
roles (security)
     application roles 2nd
     creating 2nd
     definition of 2nd
     fixed roles
     viewing list of
     viewing permissions for
ROLLBACK TRANSACTION statement 2nd
rolling back transactions 2nd
ROLLUP keyword (SELECT statement) 2nd
ROUND() function
ROWLOCK hint
rows
     counting
RTRIM() function
rules