T

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