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