C

Cache Hit Ratio counter

baselines, 234

thresholds, 238

Cache Object Counts counter, 234

Cache Pages counter, 234

CacheHit event class, 241

CacheMiss event class, 241

caching strategy, 344, 345

Cancel lock event class, 133

Cartesian products, 415

CAs (Certificate Authorities), 572

@catalog argument, 459

catalogs

checking, 299–300

updating, 316–317

CATCH/TRY construct, 114–115

Certificate Authorities (CAs), 572

certificates, 572

change control

access control, 540–542, 540–541

DDL triggers, 542–545

migration scripts, 545–546

object identification, 539

Change Manager program, 539

char data type, 441

Character Map transforms, 376

character strings, 441–442

check constraints

checking, 300

purpose, 435

in replication, 493

CHECKALLOC command, 297–299

CHECKCATALOG command, 299–300

CHECKCONSTRAINTS command, 300

CHECKDB command, 50, 207–208, 301–304

CHECKFILEGROUP command, 207, 305–306

CHECKIDENT command, 304–305

Checkpoint Pages/sec counter, 232

checkpoints, SSIS packages, 380–382

CheckPointUsage property, 381

CHECKSUM option

BACKUP LOG, 193

data integrity, 424–425

RESTORE DATABASE, 197

CHECKTABLE command, 207, 306–307

CIM (Common Information Model) initiative, 253

cipher text, 570

cleansing data, 426

CLEANTABLE command, 51, 307–308

client applications

monitoring, 228–229

in performance, 4

client statistics, 77, 77

CLR (common language runtime) environment

DMVs, 33–34

user-defined types, 444–445

clustered indexes, 97–98

clustering, failover, 169–172, 170–171

CNVT lock request state, 132

cold standby solutions, 165

Collation Compatible option, 463

Collation Name option, 463

command prompt for agent profiles, 510

Common Information Model (CIM) initiative, 253

common language runtime (CLR) environment

DMVs, 33–34

user-defined types, 444–445

compatibility, lock, 129–131

compilations

recompiling, 89–90

troubleshooting, 39–40, 41

complete data, 402

Completed event class, 241

concise and unique data representation, 402

concurrency, 116–118

latches, 118–122

locks. See locks

replication baselines, 513

condition alerts, 250–253, 251–252

Conditional Split transforms, 376

Configuration Changes History report, 25

configuration settings, SQLH2 for, 323

Configure Replication Alerts dialog box, 499–500, 499

conflict resolution policies, 431

conflicts, 427

ETL master data approach, 434

job dependency diagrams for, 320–321

multiple copies, single maintenance approach, 427–428

multiple master approach

merge replication, 432–433, 432

peer-to-peer replication, 433–434, 433

plan design for, 505–508, 506–508

single copy approach, 427

updatable copies, single master approach, 429–432, 429–431

CONNECT permission, 579

connection managers, 365

Connection Timeout option, 464

@@CONNECTIONS function, 32

consistency, database. See database consistency checks

consistent data, 402

constraints

checking, 300

for integrity, 434–439, 434, 436–437

replication, 492–493

vs. triggers, 445

Context Switches/sec counter, 235

CONTINUE_AFTER_ERROR option

BACKUP LOG, 193

RESTORE DATABASE, 197

contract forms, Service Broker, 276

control flow for SSIS packages, 365, 368, 373–374

CONTROL permission, 579

Copy Column transforms, 376

COPY_ONLY option, 192

costs in query plans, 83–84

counters. See performance object counters

covering indexes, 100–101

CPU resources in query plans, 83

create, read, update, and destroy (CRUD) cycle, 404

CREATE ASYMMETRIC KEY statement, 572

CREATE CLUSTERED INDEX statement, 98

CREATE DATABASE statement, 189

CREATE EVENT NOTIFICATION statement, 274, 280

CREATE INDEX statement, 95–96, 101, 107–108, 111

CREATE LOGIN statement, 205, 578

CREATE MASTER KEY statement, 573

CREATE NONCLUSTERED INDEX statement, 99

CREATE permission, 579

CREATE QUEUE statement, 280

CREATE SERVICE statement, 280

CREATE SYMMETRIC KEY statement, 571

CREATE TABLE statement, 100, 493

Create the Publication Selection option, 485

CREATE TRIGGER statement

DDL triggers, 270, 544–545

DML triggers, 264

encryption, 494

replication, 493

CREATE XML INDEX statement, 96–97

Creating Publication page, 485, 485

Creating Subscription(s) page, 489

credentials, login, 579

cross joins, 415–417, 416

CRUD (create, read, update, and destroy) cycle, 404

cursor data type, 443

CURSOR entity, locks for, 127