Inside Microsoft SQL Server 2005: The Storage Engine (Solid Quality Learning)
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] sample databases scale Scan For Startup Procs configuration option scheduler binding to CPUs dedicated administrator connection (DAC) dynamic affinity Non-Uniform Memory Access (NUMA) observing internals overview SQL Server schedulers SQL Server tasks SQL Server workers threads vs. fibers scheduler_id column 2nd scheduling configuration options schema modification locks schema stability locks schemas compared to databases default separation of principals and schemas secondary data files securable vs. object security database [See database security] pre-installation decisions Serializable isolation SERIALIZABLE keyword Server Trigger Recursion configuration option Service Broker database options service name services disabling nonessential managing session ID (SPID) session_id column SET options Set Working Set Size configuration option 2nd Shared Global Allocation Map (SGAM) pages shared locks 2nd Shared Memory protocol Show Advanced Options configuration option shrinking databases 2nd SI (SNAPSHOT isolation) 2nd SIMPLE recovery model single-byte characters (char and varchar) single_pages_in_use_kb column single_pages_kb column 2nd SINGLE_USER database option size column sizing buffer pools memory configurations multiple instances on a single computer Non-Uniform Memory Access (NUMA) observing memory internals overview read-ahead memory mechanism Target Memory value sizing memory smalldatetime values SMO and DMO XPs configuration option snapshot isolation behaviors allowed Data Definition Language (DDL) database options overview 2nd RCSI vs. SI 2nd READ COMMITTED SNAPSHOT isolation (RCSI) scope SNAPSHOT isolation (SI) snapshot transaction metadata sys.databases catalog view types of update conflicts version store snapshots, database creating managing overview space used by software requirements sort orders binary sorting overview performance considerations semantics specifying collation sorting, index space allocation in databases space monitoring in tempdb database space requirements in indexes special indexes COLUMNPROPERTY function computed columns deterministic vs. nondeterministic functions implementation overview persisted columns prerequisites schema binding SET options views 2nd SPID (session ID) spinlocks splitting pages in indexes SQL database options 2nd SQL Enterprise Manager SQL Mail XPs configuration option SQL manager SQL Native Client SQL operating system (OS) binding schedulers to CPUs dedicated administrator connection (DAC) dynamic affinity NUMA and schedulers NUMA architecture observing scheduler internals overview scheduler overview SQL Server schedulers SQL Server tasks SQL Server workers threads vs. fibers SQL Query Analyzer 2nd SQL Server 2005 Upgrade Advisor SQL Server authentication SQL Server Books Online 2nd SQL Server Configuration Manager [See also configurations] configuring network protocols default network protocols managing services overview SQL Server Database Services [See also database engine] clustering full-text search overview replication SQL Server Enterprise Manager SQL Server Management Studio 2nd 3rd SQL Server schedulers SQL Server storage engine access methods overview controlling utilities locking operations overview page allocation operations row and index operations transaction services versioning operations SQL Server tasks SQL Server workers SQL-92 reserved keywords sql_variant data 2nd SQLOS layer binding schedulers to CPUs dedicated administrator connection (DAC) dynamic affinity NUMA and schedulers NUMA architecture observing scheduler internals overview scheduler overview SQL Server schedulers SQL Server tasks SQL Server workers threads vs. fibers stack_bytes_used column Standard Edition standby files started_by_sqlservr column state column state database options EMERGENCY emergency mode repair MULTI_USER NO_WAIT OFFLINE ONLINE overview 2nd READ_ONLY RESTRICTED_USER ROLLBACK AFTER integer [SECONDS] ROLLBACK IMMEDIATE SINGLE_USER termination options state_desc column statistic updates during upgrades storage engine access methods overview controlling utilities locking operations overview page allocation operations row and index operations transaction services versioning operations storage of data LOB data metadata sql_variant data varchar(MAX) data structure of indexes clustered index node rows clustered index rows with uniqueifier DBCC IND command index row formats nonclustered index leaf rows nonclustered index node rows overview sys.system_internals_allocation_units view Surface Area Configuration Tool 2nd SWITCH option to ALTER TABLE command sys.allocation_units view sys.database_files view sys.databases catalog view 2nd sys.dm_db_file_space_usage view sys.dm_db_index_physical_stats function sys.dm_db_session_space_usage view sys.dm_db_task_space_usage view sys.dm_os_memory_cache_clock_hands view sys.dm_os_memory_cache_counters view sys.dm_os_memory_cache_hash_tables view sys.dm_os_memory_clerks view sys.dm_os_schedulers view sys.dm_os_tasks view sys.dm_os_threads view sys.dm_os_waiting_tasks view sys.dm_os_workers view sys.dm_tran_locks view 2nd sys.indexes view sys.partitions view sys.system_internals_allocation_units view syslockinfo table system base tables system catalogs system configurations [See also configurations] compatibility with earlier SQL Server versions default trace network protocols nonessential services overview resource allocation settings [See configuration settings] system paging file location task management trace flags system databases 2nd system functions system objects catalog views compatibility views information schema views overview system functions system stored procedures system paging file location system stored procedures |