Index C

[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]

cache
       permanent residence   2nd  
       tables  
caching
       queries
               stored procedures   2nd  
CAL (client access license)  
CAL (Server/Per-Seat Client Access License)  
Calculated Cells Wizard, AS  
calculated members , OLAP databases   2nd   3rd  
capitalization, naming standards and  
Cartesian products  
cascading deletes, triggers   2nd   3rd   4th   5th  
Cascading Referential Integrity   2nd   3rd  
cascading RI constraints   2nd  
cascading updates, triggers   2nd   3rd   4th   5th  
CASE expression   2nd   3rd  
case sets  
catalogs, database catalogs  
categories
       system stored procedures   2nd  
cells
       AS and  
central publisher model scenario, replication   2nd   3rd   4th  
central publisher with remote distribution scenario, replication   2nd   3rd  
central subscriber scenario, replication  
char datatype  
character datatypes   2nd   3rd  
character format, BCP utility and  
Chart view, Performance Monitor  
CHECK constraints   2nd  
check constraints
       restrictions  
CHECK statements  
checkpoint  
checkpoints
       transaction logs   2nd   3rd   4th   5th   6th   7th   8th  
checkpoints, memory management   2nd   3rd  
class library
       .NET Framework   2nd  
clauses
       ORDER BY   2nd  
       WHERE   2nd   3rd   4th  
clauses, SQL
       English Query and   2nd  
client access license (CAL)  
Client Network Utility   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
Client Statistics, Query Analyzer   2nd  
client-side Net-Libraries   2nd  
client/server architecture
       evolution of   2nd  
       n- tier client/server  
       RDBMS   2nd  
       three-tier client/server  
       two-tier client/server   2nd  
clients  
       administration
               MTS and  
       architecture   2nd   3rd   4th  
       cascading updates  
       configuration   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
       connections, troubleshooting   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
       DB-Library applications  
       e-mail
               setup   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th  
       installation
               options   2nd   3rd   4th   5th  
       Net-Library  
       network protocol support   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st  
       network software  
       ODBC applications  
       OLE DB consumers  
       overview   2nd   3rd   4th   5th   6th   7th   8th  
       software
               connection troubleshooting and  
       system requirements   2nd  
       tools
               installation   2nd   3rd   4th   5th   6th  
closing cursors  
Clustered Index, Query Analyzer   2nd   3rd  
clustered indexes   2nd   3rd   4th   5th   6th  
       design guidelines   2nd   3rd   4th  
       heap tables   2nd   3rd  
        nonunique   2nd   3rd   4th   5th   6th   7th   8th   9th  
       query optimization and   2nd  
       row structure   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
       size
               estimating   2nd   3rd   4th   5th  
clustered tables   2nd  
clustering  
       enhancements  
        fail-over support and   2nd   3rd   4th   5th  
       failover cluster configuration   2nd  
       fault tolerance and  
       MSCS   2nd   3rd  
       nodes  
code
       transactions, effective   2nd  
coding guidelines, stored procedures   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
collation
       default   2nd  
       enhancements   2nd  
Collation Designer  
column datatype indicators, naming standards   2nd  
column expressions, queries
       subqueries  
column-level constraints  
columns
       computed columns, indexes   2nd   3rd   4th   5th  
       data columns, traces   2nd   3rd   4th   5th  
       datatypes
               changing   2nd   3rd  
       defining
               T-SQL   2nd  
       grouping   2nd  
       identity
               T-SQL   2nd  
       limitations  
        names   2nd   3rd   4th   5th   6th   7th   8th  
       properties
               T-SQL   2nd   3rd   4th  
       security, views and   2nd   3rd  
       size limits  
       sql_variant datatype and  
       surrogate primary key  
       Table Designer  
       tables
               BCP utility   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th  
               T-SQL   2nd   3rd   4th   5th   6th   7th  
       updates
               triggers and   2nd   3rd   4th   5th  
COM
       MTS and  
command line utilities
       itwiz   2nd   3rd   4th   5th  
command object, ADO.NET  
command-line utilities   2nd  
       BCP   2nd   3rd  
       DTS   2nd   3rd  
       ISQL   2nd   3rd  
        makepipe   2nd   3rd  
       ODBCcmpt  
        odbcping   2nd   3rd  
       OSQL   2nd   3rd  
       readpipe   2nd   3rd  
        rebuildm   2nd   3rd   4th  
        regrebld   2nd   3rd  
commands
       ALTER DATABASE  
       ALTER FUNCTION  
       ALTER TABLE  
       ALTER TRIGGER  
       BACKUP  
       BACKUP DATABASE   2nd   3rd   4th   5th   6th  
       BACKUP LOG   2nd  
       batches   2nd   3rd  
       BEGIN TRAN  
       BULK INSERT  
       CREATE RULE   2nd   3rd  
       DBCC   2nd   3rd   4th   5th  
       DBCC PERFOM  
       DBCC PROCACHE   2nd   3rd  
       DBCC SHRINKFILE  
       DROP VIEW  
       DROP_INDEX  
       DUMP  
       English Query  
       RAISERROR  
       RESTORE LOG  
       SAVE TRAN  
       Search Server   2nd   3rd   4th   5th   6th   7th  
       UPDATE STATISTICS  
comments   2nd   3rd  
COMMIT statement  
compatibility
       locks   2nd  
compiling.   [See also query compilation]
completely linked servers  
completion queue  
component-level objects, Notification Services  
composite indexes
       design guidelines  
composite indexes, multiple indexes comparison   2nd  
COMPUTE BY keyword
       aggregate function   2nd   3rd   4th   5th   6th  
COMPUTE keyword
       aggregate functions   2nd   3rd   4th   5th   6th  
Compute Scalar operator, Query Analyzer  
computed columns, denormalization and   2nd   3rd  
computed columns, indexes   2nd   3rd   4th   5th  
Concatenation operator, Query Analyzer  
concatenation, strings  
concurrency model, .NET   2nd  
       optimistic concurrency   2nd   3rd   4th   5th  
configuration
       advanced options  
       affinity mask   2nd   3rd   4th  
       Agent  
               mail profile   2nd  
               proxy account   2nd  
               startup account  
                user connections   2nd  
       allow update   2nd   3rd  
       AWE enabled   2nd  
       clients   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
       cost threshold for parallelism   2nd  
       cursor threshold   2nd  
       default language  
       error log  
       fill factor   2nd  
       incorrect settings  
       index create memory  
       instances, Notification Services   2nd   3rd   4th   5th   6th   7th  
       lightweight pooling   2nd  
       linked servers   2nd   3rd   4th   5th   6th   7th  
       locks   2nd   3rd   4th   5th  
       Mail   2nd   3rd   4th  
       max degree of parallelism   2nd  
       max text repl size  
       max worker threads   2nd   3rd  
       memory
               max server   2nd   3rd   4th  
               min server   2nd   3rd   4th  
       min memory per query   2nd  
       MTS security   2nd   3rd   4th   5th   6th   7th  
       nested triggers  
       network packet size   2nd   3rd  
       obsolete options   2nd  
       ODBC datasources  
        open objets  
       options
               Enterprise Manager and   2nd  
       options at installation   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
       options for   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
       post-installation   2nd   3rd  
       priority boost   2nd  
       queries
               wait  
       query governor cost limit   2nd   3rd  
       recovery interval   2nd   3rd  
       remote proc trans   2nd  
       scan for startup procs  
       servers
               Enterprise Manager   2nd   3rd   4th  
       SQLAgentMail   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
       user connections   2nd  
       user options   2nd   3rd   4th  
       working set size   2nd  
configuration files
       instances, Notification Services  
       Query Analyzer  
configuration functions   2nd   3rd   4th   5th   6th  
conflict resolvers  
connecting to SQL Server
       installation  
connection pooling, MTS   2nd   3rd   4th  
connection pooling, MTS and  
connection-specific functions   2nd   3rd   4th   5th  
connections
       bound
               transactions   2nd   3rd   4th   5th   6th   7th   8th  
       client
               troubleshooting   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
       ODBC
               troubleshooting   2nd   3rd  
       security
               Internet   2nd  
       SQL Server, Internet and   2nd   3rd   4th  
       users
               Agent   2nd  
consistency checks
       VLDB   2nd  
Consistency, ACID property  
consistency, stored procedures and  
Constant Scan operator, Query Analyzer   2nd  
constraints  
       ALTER TABLE command  
       CHECK constraints   2nd  
       colum-level  
       creating   2nd  
               Enterprise Manager   2nd   3rd  
               T-SQL   2nd   3rd   4th  
       disabling   2nd   3rd  
       dropping  
       information gathering  
       managing   2nd   3rd   4th  
       names   2nd   3rd   4th  
       PRIMARY KEY   2nd  
       referential integrity   2nd   3rd   4th   5th  
       table-level  
       tables
               T-SQL   2nd   3rd  
       UNIQUE   2nd  
CONTAINS( ) function   2nd   3rd   4th  
CONTAINSTABLE( ) function   2nd  
content formatter, notification distribution  
contention , locking   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st   22nd   23rd   24th   25th   26th   27th   28th   29th   30th   31st   32nd  
contextual information, English Query  
continuation media  
CONTINUE statement   2nd  
control-of-flow statements
       functions and  
correlated subqueries   2nd   3rd  
corrupt databases   2nd   3rd  
cost threshold for parallelism, configuration   2nd  
cost-based optimizers  
COUNT_BIG( ) function  
counters
       Performance Monitor   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th  
               user-defined   2nd   3rd  
       Windows performance monitoring   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st   22nd   23rd   24th   25th   26th   27th   28th   29th  
               disk usage   2nd   3rd   4th   5th  
               network interface   2nd   3rd   4th   5th  
               processors   2nd   3rd  
counters, Performance Monitor   2nd   3rd  
covering indexes, design and   2nd   3rd   4th   5th   6th  
Create and Manage Publications dialog box  
Create Database Wizard   2nd  
CREATE FUNCTION statement  
Create Index Wizard  
CREATE RULE command   2nd   3rd  
CREATE statement
       T-SQL
               linked servers and  
CREATE TABLE
       constraint creation  
CREATE VIEW statement  
CREATE_DATABASE DDL command  
CREATE_DATABASE statement  
CREATE_INDEX command
       arguments   2nd  
       T-SQL   2nd   3rd  
CREATE_INDEX statement
       VLDB  
CREATE_TABLE command  
CREATE_TABLE DDL command  
CREATE_TABLE statement
       identity columns  
CROSS joins  
CUBE operator
        GROUP BY statement   2nd   3rd   4th  
Cube Wizard, AS  
cubes
       aggregations  
       browsing, Analysis Manager and   2nd   3rd   4th  
       business-are focused   2nd   3rd   4th   5th   6th  
       creating   2nd  
       defined  
       linked cubes  
       local cubes  
       partitioning   2nd  
       processing
               OLAP databases   2nd  
       real-time cubes  
       regular cubes  
       virtual cubes   2nd   3rd  
       write-enabled cubes  
Current Activity folder, Enterprise Manager   2nd  
cursor operations, functions and  
cursor options  
CURSOR STATUS function   2nd  
cursor threshold, configuration   2nd  
CURSOR variables
       stored procedures   2nd   3rd   4th   5th   6th   7th   8th  
cursors
       datatypes
               stored procedures  
       stored procedures   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th  
               deallocating  
       support  
       T-SQL   2nd   3rd   4th  
               API   2nd   3rd   4th   5th   6th  
               closing  
               deallocating   2nd  
               declaring   2nd   3rd   4th   5th   6th  
               DYNAMIC   2nd  
               example   2nd   3rd  
               fetching rows   2nd  
               FORWARD ONLY  
               information about   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
               INSENSITIVE   2nd  
               KEYSET   2nd  
               local/global   2nd  
               main loop   2nd  
               opening   2nd  
               rows, modifying   2nd  
               scrollable cursors   2nd   3rd  
               STATIC   2nd  
               syntax   2nd   3rd  
               variables   2nd   3rd   4th   5th   6th   7th  
               variables, declaring   2nd  
               when to use   2nd   3rd   4th   5th   6th  
Custom installation