C

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