C

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

C#
     base-64 encoding and decoding 2nd
    stored procedures, writing
         saving XML data to file 2nd 3rd 4th
calculating
     query plan cost 2nd 3rd
Call Stackwindow (BIDS)
calling
     xml data type methods
capturing
     blocked process reports 2nd 3rd 4th 5th 6th
catalog security 2nd
catalog views 2nd 3rd 4th 5th 6th
     for Service Broker 2nd
     HTTP SOAP 2nd
certificates
     Service Broker, security
Character Map transformation
Check Database Integrity task
checksum I/O transactions
     validating 2nd
cleansing data
clients
     SSIS
CLR
     appdomains
         sys.dm clr
    integration with SQL
         benefits of 2nd
         catalog views 2nd
         challenges 2nd
         examples 2nd 3rd 4th 5th 6th
         monitoring activity 2nd 3rd
CLR (common language runtime
CLR hosting
     design goals 2nd
CLR support 2nd
     as replacement for extended stored procedures
CLS (Common Language Specification)
clusters
     active-active
code access security in .NET Framework
     permissions 2nd
color-coding of SSIS execution status
columns
    non-key
         including in indexes
     partition columns
     persisted computed columns
COM APIs
     WMI
COM objects
     WMI providers
Command window (BIDS)
command-line switches (SQLCMD) 2nd 3rd
command-prompt utilities
     DTExec
     DTExecUI
     DTUtil
commands (SQLCMD)
common caching framework
comparing
     Service Broker and BizTalk Server
     Service Broker and Indigo
     Service Broker and MSMQ
     SQL Server 2000 and SQL Server 2005 2nd
compatibility views 2nd
computed columns 2nd 3rd 4th
Conditional Split transformation
configuring
     blocked process threshold 2nd 3rd 4th 5th 6th
     database mail 2nd 3rd 4th
     database mirroring 2nd 3rd
     NUMA affinity 2nd
     tables with SQL Server Management Studio 2nd 3rd 4th
consolidation
constraints
     creating for tables 2nd 3rd 4th
     precedence constraints
constructing
     XML with XQuery, example 2nd
constructors (XQuery)
containers 2nd
     For Loop container
     Foreach Loop container
     Sequence container 2nd
     Task Host container
context switches
contracts
     creating 2nd
CONTROL permission
control-flow tasks
     Analysis Services tasks
     data-oriented tasks
     process-oriented workflow tasks
     Scripting tasks
     SQL Server tasks
controlling system metadata access 2nd 3rd
     catalog security 2nd
     catalog views 2nd
conversation groups
conversations
cooperative thread scheduling
copy-on-write operation
     database snapshots
Copy/Map transformation
cost of query plans
     calculating 2nd 3rd
counters (Perfmon)
     for Service Broker 2nd
counters, Performance Monitor 2nd
covering indexes 2nd 3rd
     creating
     versus non-key included columns
CREATE ASSEMBLY DDL statement
CREATE ENDPOINT statement (T-SQL)
CREATE LOGIN DDL statement, options 2nd
creating
     assemblies
     asymmetric keys
     contracts 2nd
     covering indexes
     database master keys
     database snapshots 2nd
    endpoints
         for database mirroring
         HTTP 2nd 3rd 4th
         Service Broker 2nd
     indexes on computed columns 2nd
     indexes on xml type columns 2nd
         primary XML indexes 2nd 3rd
         secondary XML indexes
     indexes with computed columns 2nd
     message types 2nd
     new logins
     nonclustered indexes
     plan guides 2nd 3rd 4th
     primary XML indexes 2nd 3rd
     queues 2nd
     reports 2nd
     secondary XML indexes 2nd 3rd
     services 2nd
     symmetric keys
     synonyms
     typed XML 2nd 3rd 4th 5th 6th 7th 8th
creating new databases with SQL Server Management Studio 2nd
creating schema 2nd
creating SQL authenticated logins
cryptography
     data encryption
         asymmetric keys
         symmetric keys 2nd 3rd 4th
     key management
         symmetric keys 2nd 3rd 4th
CTEs
     recursive
CTEs (common table expressions) 2nd 3rd 4th 5th 6th 7th
CTS (Common Type System)
cubes
     creating from scratch
     data sparsity
     Intellicube
    multiple fact tables
         support for on Analysis Services 2005
     perspectives
     processing