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]

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



Inside MicrosoftR SQL ServerT 2005. The Storage Engine
Inside Microsoft SQL Server 2005: The Storage Engine (Solid Quality Learning)
ISBN: 0735621055
EAN: 2147483647
Year: 2004
Pages: 115
Authors: Kalen Delaney

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net