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] C2 Audit Mode configuration option caching optimizations in tempdb database catalog views 2nd 3rd changes in log size 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 changing data types char and varchar (single-byte characters) character data types character sets CHECK constraint checkpoints CHECKSUM database option clock_hand column clock_status column CLR data types CLR Enabled configuration option clustered indexes node rows overview rows with uniqueifier clustering collation pre-installation decisions specifying column offset array columns in tables adding dropping overview command parser compatibility database levels earlier SQL Server versions views components AdventureWorks Analysis Services Books Online database engine 2nd Development Tools Integration Services Notification Services overview Reporting Services selecting for installation SQL Enterprise Manager SQL Query Analyzer SQL Server Database Services SQL Server Management Studio 2nd 3rd SQLCMD Workstation Components computed columns in indexes CONCAT_NULL_YIELDS_NULL database option concurrency [See also locking] ACID properties atomicity in transactions consistency in transactions durability in transactions isolation in transactions isolation levels models 2nd optimistic overview pessimistic Read Committed isolation 2nd Repeatable Read isolation 2nd row versioning [See row versioning] Serializable isolation snapshot isolation [See snapshot isolation] transaction processing overview Uncommitted Read isolation 2nd Configuration Manager [See also configurations] configuring network protocols default network protocols managing services overview configuration settings Ad Hoc Distributed Queries option advanced Affinity I/O Mask option 2nd Affinity Mask option 2nd Affinity64 I/O Mask option 2nd Affinity64 Mask option 2nd Agent XPs option Allow Updates option available options AWE Enabled option 2nd Blocked Process Threshold option 2nd C2 Audit Mode option changing CLR Enabled option Cost Threshold For Parallelism option 2nd Cross Db Ownership Chaining option Cursor Threshold option Database Mail XPs option Default Full-Text Language option Default Language option Default Trace Enabled option Disallow Results From Triggers option disk I/O options Fill Factor option Ft Crawl Bandwidth (max) option FT Crawl Bandwidth (min) option FT Notify Bandwidth (max) option FT Notify Bandwidth (min) option In-Doubt Xact Resolution option Index Create Memory option 2nd Lightweight Pooling option 2nd list of available options list of property pages Locks option 2nd Max Degree Of Parallelism option 2nd Max Full-Text Crawl Range option Max Server Memory option 2nd Max Text Repl Size option Max Worker Threads option 2nd Media Retention option memory options Min Memory Per Query option 2nd Min Server Memory option 2nd Nested Triggers option Network Packet Size option Ole Automation Procedures option Open Objects option overview PH_Timeout option Precompute Rank option Priority Boost option 2nd property pages Query Governor Cost Limit option 2nd query processing options Query Wait option 2nd Recovery Interval option 2nd Remote Access option Remote Admin Connections option Remote Login Timeout option Remote Proc Trans option Remote Query Timeout option Scan For Startup Procs option scheduling options Server Trigger Recursion option Set Working Set Size option 2nd Show Advanced Options option SMO and DMO XPs option SQL Mail XPs option Transform Noise Words option Two Digit Year Cutoff option User Connections option 2nd User Instance Timeout option User Instances Enabled option User options Web Assistant Procedures option xp_cmdshell option configurations compatibility with earlier SQL Server versions Configuration Manager [See Configuration Manager] default trace network protocols nonessential services overview resource allocation settings [See configuration settings] system configuration overview system paging file location task management trace flags configuring network protocols consistency in transactions constraints adding catalog views compared to CREATE INDEX command data integrity declarative data integrity disabling domain integrity dropping enabling entity integrity failures IDENTITY property indexes integrity checks multiple-statement transactions names overview programmatic data integrity transaction errors types context_switches_count column controlling locking conversion locks copying databases Cost Threshold For Parallelism configuration option 2nd cpu_id column CREATE DATABASE command 2nd CREATE INDEX command WITH clause compared to constraints DROP_EXISTING option FILLFACTOR option MAXDOP option ONLINE option overview SORT_IN_TEMPDB option STATISTICS_NORECOMPUTE option UNIQUE option CREATE TABLE command creating database snapshots creating databases creating indexes constraints CREATE INDEX command vs. constraints CREATE INDEX options included columns overview placement creating tables binary data types bit data type bracketed identifiers character data types choosing data types CLR data types cursor data type data types overview date data types delimited identifiers Hungarian-style notation large object (LOB) data types naming conventions naming tables and columns NOT NULL NULL numeric data types overview quoted identifiers reserved keywords rowversion data type sql_variant data type table data type time data types uniqueidentifier data type user-defined data type (UDT) creation_time column Cross Db Ownership Chaining configuration option current_tasks_count column current_workers_count column cursor data type cursor database options 2nd Cursor Threshold configuration option CURSOR_CLOSE_ON_COMMIT {ON | OFF} database option CURSOR_DEFAULT {LOCAL | GLOBAL} database option |