Index[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) configurations SQL Server installations RAM, SQL Server installations RAW mode, FOR XML statements read-only secondary servers readiness for CISA exam real data type RECEIVE statements, dialogues recovery models ALTER DATABASE statements, SET RECOVERY option sp dboption stored procedure T-SQL replication central subscriber database administrators distributors role in 2nd latency merge 2nd publishers role in push/pull subscriptions site autonomy snapshot 2nd subscribers role in transactional 2nd RESTORE command Restore Database dialog From Device option General page Options page RESTORE statements FILELISTONLY option HEADERONLY option LABELONLY option VERIFYONLY option WITH RECOVERY option WITH REPLACE option WITH STANDBY option WITH STOPAT option RESTORE VERIFYONLY option Restrict Access to the Restored Database option (Restore Database dialog) Results window (SQL Profiler) REVOKE statements, data deletion privileges REWIND option, BACKUP statements RIGHT JOIN statements ROLLBACK statements rows access patterns (partitioning tables) deleting data, TRUNCATE TABLE method null value rows, selecting top rows, returning RTRIM (right trim) function |