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] table data type table-level hints tables adding columns catalog views changing data types column offset array compatibility views constraint catalog views constraint failures constraint names constraints overview creating [See creating tables] data pages data rows data storage metadata fixed-length rows IDENTITY property information schema views integrity checks internal storage overview LOB data methods for modifying modifying modifying constraints multiple-statement transactions overview page linkage partitioning property functions querying catalog views row-overflow data sql_variant data sys.indexes view system functions system objects overview system stored procedures table-level vs. index-level modifications transaction errors varchar(MAX) data variable-length rows TABLOCK keyword TABLOCKX keyword tabular data stream (TDS) 2nd Target Memory value task management for system configurations task_state column tasks TCP/IP protocol TDS (tabular data stream) 2nd tempdb database allocation optimizations best practices caching optimizations internal objects logging optimizations object types optimizations overview 2nd space monitoring sys.dm_db_file_space_usage view sys.dm_db_session_space_usage view sys.dm_db_task_space_usage view user objects version store termination database options text data type threads vs. fibers time data types timestamp data type TORN_PAGE_DETECTION database option trace flags trace, default Transact-SQL CREATE DATABASE command transaction errors transaction logs backing up databases [See backing up databases] changes in log size [See changes in log size] log sequence numbers (LSNs) overview reading logs recovery phases restoring databases [See restoring databases] transaction processing ACID properties atomicity consistency dirty reads durability explicit transactions implicit transactions inconsistent analysis isolation isolation levels lost updates non-repeatable reads overview phantoms Read Committed isolation 2nd Repeatable Read isolation 2nd Serializable isolation snapshot isolation [See snapshot isolation] Uncommitted Read isolation transaction sequence number (XSN) transaction services Transform Noise Words configuration option triggers 2nd TRUNCATEONLY option tuples Two Digit Year Cutoff configuration option type column type_desc column |