L

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]

large object (LOB) data 2nd 3rd
latches vs. locks
Lightweight Pooling configuration option 2nd
load_factor column
LOB (large object) data 2nd 3rd
Locale column
lock blocks
lock compatibility
lock duration
lock escalation
lock hints
lock modes
     bulk update locks 2nd
     conversion locks
     exclusive locks 2nd
     intent locks 2nd
     key-range locks
     overview
     schema modification locks
     schema stability locks
     shared locks 2nd
     update locks 2nd
lock owner blocks
lock ownership
lock partitioning
lock resources
LOCK_TIMEOUT option
locking [See also concurrency]
     ALLOCATION_UNIT locks
     application locks
     associated entity ID
     bound connections
     bulk update locks 2nd
     controlling
     conversion locks
     data modifications in indexes
     databases
     deadlocks
     examples
     exclusive locks 2nd
     extents
     granularity
     HOBT locks
     intent locks 2nd
     internal architecture
     key-range locks 2nd
     latches vs. locks
     lock blocks
     lock compatibility
     lock duration
     lock escalation
     lock hints
     lock modes
     lock owner blocks
     lock ownership
     lock partitioning
     lock resources
     lock types for user data
     LOCK_TIMEOUT option
     Multiple Active Result Sets (MARS)
     number of slots in hash table
     overview 2nd
    row versioning [See row versioning]
     row-level vs. page-level
     schema modification locks
     schema stability locks
     shared locks 2nd
     spinlocks
     sys.dm_tran_locks view
     syslockinfo table
     timeouts
     update locks 2nd
     viewing locks
Locks configuration option 2nd
log backups
log files
    backing up databases [See backing up databases]
    changes in log size [See changes in log size]
     log sequence numbers (LSNs)
     overview 2nd
     reading logs
     recovery phases
    restoring databases [See restoring databases]
     transaction log basics
log sequence numbers (LSNs)
log size changes
     active VLFs
     automatic shrinking
     automatic truncation of VLFs
     log file size
     maintaining recoverable logs
     multiple physical log files
     observing VLFs
     overview
     recoverable VLFs
     reusable VLFs
     unused VLFs
     VLF overview
     VLF states
logging
     analysis recovery phase
    backing up databases [See backing up databases]
     Buffer Manager
     fast recovery
     index data modifications
     log sequence numbers (LSNs)
    log size changes [See log size changes]
     optimizations in tempdb database
     overview
     phases of recovery
     reading logs
     redo recovery phase
     restart recovery
     restore recovery
    restoring databases [See restoring databases]
     transaction log basics
     undo recovery phase
     write-ahead
lost updates
LSNs (log sequence numbers)