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] RCSI (READ COMMITTED SNAPSHOT isolation) 2nd 3rd Read Committed isolation 2nd READ COMMITTED SNAPSHOT isolation (RCSI) 2nd 3rd read-ahead memory mechanism READ_ONLY database option READCOMMITTED keyword READCOMMITTEDLOCK keyword READPAST keyword READUNCOMMITTED keyword reattaching databases rebuilding indexes 2nd reclaiming index pages recoverable virtual log files (VLFs) recovery analysis phase backing up databases [See backing up databases] Buffer Manager fast log sequence numbers (LSNs) log size changes [See log size changes] overview phases reading logs redo phase restart recovery restore recovery restoring databases [See restoring databases] transaction log basics undo phase write-ahead logging Recovery Interval configuration option 2nd recovery models RECURSIVE_TRIGGERS database option redo recovery phase referential integrity relational engine command parser database manager overview query executor query optimizer SQL manager release notes Remote Access configuration option Remote Admin Connections configuration option Remote Login Timeout configuration option Remote Proc Trans configuration option Remote Query Timeout configuration option removed_all_rounds_count column removing fragmentation reorganizing indexes REPAIR options for database consistency Repeatable Read isolation 2nd REPEATABLEREAD keyword replication Reporting Services reports, fragmentation reserved keywords resource allocation for system configurations resource database 2nd resource_address column resource_description column restart recovery 2nd restore recovery 2nd restoring databases [See also backing up databases, recovery] BULK_LOGGED recovery model example FULL recovery model migrating from earlier SQL Server versions moving databases overview pages partial restores recovery models restoring with standby files SIMPLE recovery model restoring files and filegroups restoring pages RESTRICTED_USER database option reusable virtual log files (VLFs) ROLLBACK AFTER integer [SECONDS] database option ROLLBACK IMMEDIATE database option root index pages rounds_count column row offset array row operations row versioning concurrency models Data Definition Language (DDL) details Multiple Active Result Sets (MARS) overview RCSI vs. SI 2nd READ COMMITTED SNAPSHOT isolation (RCSI) snapshot isolation overview SNAPSHOT isolation (SI) snapshot transaction metadata sys.databases catalog view transaction sequence number (XSN) triggers update conflicts version store row-level locking vs. page-level locking row-overflow data 2nd 3rd ROWLOCK keyword rows, index clustered index node rows clustered index rows with uniqueifier deleting from B-trees deleting from heaps deleting overview deleting rows in node levels formats forward pointers ghost records in-place updates inserting joining looking for moving nonclustered index leaf rows nonclustered index node rows not in-place updates reclaiming pages updating rows, table fixed-length in-row data LOB data maximum row length overview row offset array row-overflow data structure variable-length rowversion data type runnable_tasks_count column |