C

C# language, 334

C++ applications, 12

C2 security requirements, 134–135

CA (certificate authority), 117

Cache Manager SQL Server object, 547

caching, execution plan, 70–71

call centers, 385–386

candidate keys, 31, 35

CASCADE argument, 35, 134

cascades

stored procedures as, 413

triggers as, 380

cascading integrity, 6, 35

cascading referential integrity (CRI), 169, 441–442

CASE command, 567

CASE expressions in UPDATE statements, 439

CASE statement option, 325–326

CAST() function, 321–324

CAST command, 567

casual restores, 183

catalogs, 22, 38

CATCH (TRY…CATCH) command, 567

CCB (change control board), 128

CE operating system, Windows, 10

CEILING command, 318, 567

Celko, Joe, 356–357

cells, in tables, 26

Central Processing Units (CPUs), 58–59, 257–260, 263, 542, 555

certificate authority (CA), 117

certificate-driven security, 101

CertProperty command, 567

change control board (CCB), 128

change management, 257

char character data type, 567

char data type, 303, 308

CHAR function, 567

character strings, 291, 324

CHARINDEX function, 312, 567

CHAR(integer) function, 311

char(n) data type synonyms, 308

CHECK argument, 169–170

CHECK constraints, 35–36, 370–372, 376–377, 382

Check Credit INSTEAD OF trigger, 386

CHECK_EXPIRATION option, login creation scripts, 131

CHECK_POLICY option, login creation scripts, 131

CHECKPOINT function, 567

checks, triggers as, 380

CHECKSUM function, 319, 568

CHECKSUM_AGG function, 319, 568

checksums, 158

child elements, XML, 512

class argument, 134

class library assembly, 342, 347–348

class library, SQL Server base, 351

class module assembly, 343

Class types feature, CLS, 335

client applications, stored procedures in, 399

client cursors, 504

client Net-Libraries, 78–79

client/server architecture, 14–16

client/server database engines, 5

client/server databases, 5

client/server systems, 7–8, 15

CLOSE function, 568

CLOSE KEYS function, 568

Close-Shift sessions, 385–386

CLR (Common Language Runtime), 331–354

assemblies, 342–350

elements of, 343–347

locating, 343

overview, 342–343

role of, 347–349

strong names, 349–350

as version boundaries, 349

automatic memory management, 340–342

creating database objects, 352–353

executable code, 339

Framework Runtime, 332–336

managed execution, 339–340

metadata, 338–339

Microsoft Intermediate Language, 337–338

.NET security model, 350–351

overview, 9, 49, 331–332

side-by-side execution, 340

SQL Server base class library, 351

stored procedures and functions on, 418–420

and trigger creation, 385

CLS (Common Language Specification), 331, 333–336

Cluster Administrator, 278, 280

cluster disks, 278

Cluster Service, Microsoft, (MSCS), 261, 270–273, 278–280

clustered indexes

and constraints, 376

in CREATE TABLE statement, 169

good indexing practice, 175

ORDER argument for bulk inserts, 434

organization of, 44

overview, 33

clustering, 15–16, 257

COALESCE function, 568

code

self-describing, 338–339

trigger, 382–383

code access security, 349–350

code pages, T-SQL, 291, 303

codes, stored procedure, 410–411

COFF (Microsoft Common Object File Format), 343–344

COL_LENGTH function, 568

COL_NAME function, 568

COLLATE function, 568

collateral services, 16–20

collateral systems components, 260

collation name, 147, 155, 168

collation precedence, 308

COLLATIONPROPERTY function, 568

collations, T-SQL, 291–292, 303, 307

ColName, OpenXML SchemaDeclaration, 521

ColPattern, OpenXML SchemaDeclaration, 521

ColType, OpenXML SchemaDeclaration, 521

Column argument, 134

column identity property, 447

column names, 166, 294, 438, 453

column placeholder, 169

column_alias placeholder, 457–458

column-level constraints, 362

COLUMNPROPERTY function, 568

columns

grouping, 463

in tables, 26

COLUMNS_UPDATED() triggers, 389

COM+ Component Services, 15

command line utilities, 83

Comment (- -) operator, 561

Comment (/*…*/) operator, 562

comments element, XML documents, 511

commit directive, 64

commit phase, two-phase commit process, 502–503

COMMIT statements, 498

COMMIT TRANSACTION function, 60, 500, 568

COMMIT WORK function, 500, 568

Common Language Runtime. See CLR (Common Language Runtime)

Common Language Specification (CLS), 331, 333–336

common table expression (CTE), 14, 482–486, 609

Common Type System (CTS), 331–333

communications mechanisms, 78

comparison operators, 297

complex expressions, 294

components

monitored, 536

server-side, 75–77

compound expressions, 294–295

compressed drives, read-only filegroups on, 138

COMPUTE function, 467–469, 568

computed column expressions, 166

Computer Accounts, 114

computer telephony systems, 14–15

CONCAT_NULL_YIELDS_NULLSql_option, ALTER DATABASE statements, 157

conceptual database level, 21–23

conceptual level data integrity, 358

concurrency, 52, 60–61

concurrent access to data, 4–6

conditional updates, 439

condition-switching statements, 325

confidential data, 102–103

configuration, manual log shipping, 237

Configuration Manager, SQL Server, 78–79, 83

Configuration Wizard, Database Mail, 93

conjoined memory addressing, 55

connection contexts, 56

connection strings, mirror fail-over, 251–252

connections, SQL Server, 78–81

consistency, data, 498–499

Console executable assemblies, 342

constant_expression placeholder, 167

constants, 569

empty, 298

T-SQL, 290–294

CONSTRAINT keyword, 375

constraints.

See also data integrity

bulk insert, triggers, and, 435

and data integrity, 34–36

DML, integrity, and, 441–442

indexes on, 173–174

names, 168

and triggers, 381

CONTAINS function, 462, 569

CONTAINSTABLE function, 569

CONTEXT_INFO function, 569

CONTINUE function, 327, 569

conversion, data type, 299–300, 306

conversion functions, 321–324

CONVERT() function, 321–324

CONVERT function, 567, 569

convertible data types, 476

copies process, log shipping, 236

Copy Database Wizard, 160–162

Copy Job, SQL Server Agent, 243

COS function, 318, 569

costs, processor, 259

COT function, 318, 569

COUNT aggregate function, 319

COUNT COMPUTE argument, 467

COUNT function, 569

COUNT_BIG function, 319, 569

counter logs, 549–551

counters, performance, 539–540, 544–545

coupon codes, 326

CPUs (Central Processing Units), 58–59, 257–260, 263, 542, 555

CREATE AGGREGATE function, 569

CREATE APPLICATION ROLE function, 569

CREATE ASSEMBLY function, 569

CREATE ASYMMETRIC KEY function, 569

CREATE CERTIFICATE function, 569

CREATE CONTRACT function, 569

CREATE CREDENTIAL function, 570

CREATE DATABASE function, 144–146, 570

CREATE DEFAULT function, 570

CREATE ENDPOINT function, 570

CREATE EVENT NOTIFICATION function, 570

CREATE FULLTEXT CATALOG function, 570

CREATE FULLTEXT INDEX function, 570

CREATE FUNCTION function, 38, 417, 570

CREATE INDEX function, 32, 570

CREATE LOGIN function, 570

CREATE MASTER KEY function, 570

CREATE MESSAGE TYPE function, 570

CREATE PARTITION FUNCTION function, 570

CREATE PARTITION SCHEME function, 570

CREATE PROCEDURE function, 406–407, 408, 571

CREATE QUEUE function, 571

CREATE REMOTE SERVICE BINDING function, 571

CREATE ROLE function, 571

CREATE ROUTE function, 571

CREATE RULE function, 571

CREATE SCHEMA function, 100, 571

CREATE SERVICE function, 571

CREATE statements, 30

CREATE STATISTICS function, 571

CREATE SYMMETRIC KEY function, 571

CREATE SYNONYM function, 571

CREATE TABLE statements, 163–170, 571

arguments, 165–170

constraints syntax, 375–377

and default values, 366–367

and integrity constraint definitions, 363

overview, 29, 33

primary key constraints, 374

syntax, 163–165

CREATE TRIGGER function, 387–388, 571

CREATE TYPE function, 571

CREATE USER function, 571

CREATE VIEW function, 477, 479, 572

CRE ATE XML SCHEMA COLLECTION function, 572

credit ratings, 386

CRI (cascading referential integrity), 169, 441–442

critical restoration level, 183–184

CRM (customer relationship management), 7

CROSS JOIN, 475

cross-language integration, 337

Cryptographic Service Provider (CSP), 274

CSP (Cryptographic Service Provider), 274

CSR Shift Log AFTER Trigger, 385–386

CTE (common table expression), 14, 482–86, 609

CTS (Common Type System), 331–333

currency symbols, 293

Current Activity window, Management Studio, 533

CURRENT_REQUEST_ID function, 572

CURRENT_TIMESTAMP function, 572

CURRENT_USER function, 572

cursor data type, 305, 572

Cursor_option section, 156

CURSOR_STATUS function, 572

cursors, 62, 494, 503–507, 572

Customer attributes feature, CLS, 335

customer relationship management (CRM), 7