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 Administrator;s and User's Security Guide
C2 Audit Mode option (server properties)
C2 security audits 2nd
caching
     data cache
     procedure cache
     query execution plans 2nd
cardinality of relationships
cascade action 2nd
cascading referential integrity
CASE statement 2nd 3rd
CAST() function 2nd 3rd
casting
     data types 2nd
catalogs, Full-Text 2nd
CEILING() function
central Publisher, multiple Subscribers replication 2nd
changing
     database owner
char data type
CHAR() function
character data types 2nd
character functions 2nd 3rd
characteristic entities
CHECK constraints 2nd
checks and balances
     CHECK constraints 2nd
     COLUMN CHECK constraints 2nd
     TABLE CHECK constraints
checksum operations 2nd
CHECKSUM() function
CHECKSUM_AGG() function
CHECKSUM_BINARY() function
Chen, Peter
CISA exam
     self-assessment
         educational background
         exam readiness 2nd
         hands-on experience
         ideal Certified Information Systems Auditor candidate
Client Network
clients
     thick
     thin
CLOSE statement
closing
     cursors
clustered indexes 2nd 3rd 4th
COL_LENGTH() function
COL_NAME() function
COLLATE clause (CREATE DATABASE statement)
Collation descriptor (columns)
collation sequences 2nd
collations
COLUMN CHECK constraints 2nd
Column Name descriptor (columns)
columns 2nd
     column descriptors 2nd
commands
     DBCC (Database Console Command) 2nd 3rd
         maintenance options 2nd
         miscellaneous options 2nd
         trace flags 2nd
         validation options 2nd
comments 2nd
COMMIT TRANSACTION statement
COMMIT WORK statement
comparison operators 2nd
COMPUTE BY clause (SELECT statement)
COMPUTE clause (SELECT statement)
CONCAT_NULL_YIELDS_NULL option (databases)
concurrency 2nd 3rd
conditional data filtering
     arithmetic operators
     BETWEEN keyword
     bitwise operators
     comparison operators 2nd
     EXISTS keyword
     IN keyword
     LIKE keyword 2nd
     logical operators 2nd
     NULL values 2nd
     unary operators
conditional statements
     BREAK 2nd
     CASE 2nd 3rd
     IF...ELSE 2nd
configuration
     database configuration options 2nd
         ANSI_NULL_DEFAULT
         ANSI_NULLS
         ANSI_PADDING
         ANSI_WARNINGS
         ARITHABORT
         AUTO_CLOSE 2nd
         AUTO_CREATE_STATISTICS
         AUTO_SHRINK
         AUTO_UPDATE_STATISTICS
         CONCAT_NULL_YIELDS_NULL
         CURSOR_CLOSE_ON_COMMIT
         CURSOR_DEFAULT GLOBAL
         CURSOR_DEFAULT LOCAL
         MULTI_USER
         NUMERIC_ROUNDABORT
         OFFLINE
         QUOTED_IDENTIFIER
         READ_ONLY
         READ_WRITE
         RECOVERY BULK_LOGGED
         RECOVERY FULL
         RECOVERY SIMPLE
         RECURSIVE_TRIGGERS
         RESTRICTED_USER
         SINGLE_USER
         TORN_PAGE_DETECTION
         WITH termination (termination in italic) 2nd
     server configuration settings
         Affinity Mask
         Allow Updates
         AWE Enabled
         C2 Audit Mode
         Cost Threshold for Parallelism
         Cursor Threshold
         Default Full-Text Language
         Default Language
         Fill Factor
         Index Create Memory
         Lightweight Pooling
         Locks
         Max Degree of Parallelism
         Max Server Memory
         Max Text Repl Size
         Max Worker Threads
         Media Retention
         Min Memory Per Query
         Min Server Memory
         Nested Triggers
         Network Packet Size
         Open Objects
         Priority Boost
         Query Governor Cost Limit
         Query Wait
         Reconfigure 2nd
         Recovery Interval
         Remote Access
         Remote Login Timeout
         Remote Proc Trans
         Remote Query Timeout
         Scan for Startup Process
         Set Working Set Size
         Two Digit Year Cutoff
         User Connections
         User Options
consistency
     transactional 2nd
consistency (transactions)
constraints 2nd
     CHECK 2nd
     COLUMN CHECK
     definition of
     FOREIGN KEY 2nd
     PRIMARY KEY 2nd 3rd
     TABLE CHECK
contention (locks) 2nd
CONTINUE statement
convergence
CONVERT() function 2nd
converting
     data types 2nd
copying
     BCP (Bulk Copy Program) 2nd 3rd 4th
Cost Threshold for Parallelism option (server properties)
COUNT() function
COUNT_BIG() function
covering indexes 2nd
CREATE DATABASE statement 2nd 3rd 4th
     COLLATE clause
     FILEGROWTH clause
     MAXSIZE clause 2nd
CREATE FUNCTION statement 2nd
CREATE INDEX statement 2nd 3rd
CREATE PROCEDURE statement 2nd 3rd
CREATE TRIGGER statement 2nd
CREATE VIEW statement 2nd
cross joins 2nd
CUBE keyword (SELECT statement) 2nd
Current Activity view 2nd 3rd 4th 5th 6th
cursor data type
Cursor Threshold option (server properties)
CURSOR_CLOSE_ON_COMMIT option (databases)
CURSOR_DEFAULT GLOBAL option (databases)
CURSOR_DEFAULT LOCAL option (databases)
cursors 2nd 3rd 4th 5th 6th
     closing
     creating 2nd
     deallocating
     DYNAMIC
     FAST_FORWARD
     fetching rows from
     FORWARD_ONLY
     GLOBAL
     KEYSET
     LOCAL
     OPTIMISTIC
    options
         CURSOR_CLOSE_ON_COMMIT
         CURSOR_DEFAULT GLOBAL
         CURSOR_DEFAULT LOCAL
     READ_ONLY
     SCROLL_LOCKS
     scrolling
     STATIC
     TYPE_WARNING
     updating 2nd