C

CAB files, failed installation affecting, 49–50

cache

coherency of, 397

data cache, clearing, 467

plan cache, clearing, 467

processor cache, 349–350

Cache Hit Ratio, 389

case sensitivity of collation, 24–25

catalog views

of CLR assembly, 286

of database mirroring, 560–563, 574, 578

of event notifications, 433

of Service Broker, 254–255, 264–266, 286

of stored procedures, 287

CC-NUMA, 395–396

cell local memory, 345

Cellular Multiprocessing (CMP), 395–396

Certificate authentication, for transport security, 243–246, 263

change management

DDL triggers for

creating, 324, 327–328

database triggers, 324–329

disabling, 328–329

enabling, 329

events monitored, list of, 325, 329

server triggers, 329–330

views of, 330

projects for, 321–323

sqlcmd program for

definition of, 330

executing from command prompt, 330–332

executing from Management Studio, 332–334

initialization files for, 331–332

version tables for, 337–338

change scripts, 334–337

char data type, 10

character data types, list of, 10

character set, 24–27

CHECKPOINT process, suspending at startup, 83

CLR (Common Language Runtime) integration

application domains and, 273, 274–275, 289–290

assembly for

altering, 285

catalog view of, 286

creating, 277–280

deploying, 280–286

dropping, 285–286

loaded, listing, 291

registering, 282–285

security for, 281–282

cataloging objects in, 286–289

configuring, 80

default settings for, 75

enabling, 79, 276–277

extended stored procedures compared to, 276

features for, 12

memory usage of, 291

performance monitoring for, 290–292

scalar function, 287–288

SQL Server as .NET runtime host, 273–274

stored procedures, catalog view of, 287

support for, by SQL Server edition, 14

T-SQL compared to, 275

Table Valued Functions, 288

trigger, 287

user-defined aggregates, 288

user-defined types, 288–289

Cluster Administrator

checking SQL Server clustering, 688–689

creating resource group, 677

maintaining cluster using, 693

manually initiating a failover, 691–692

clustered index scan

ordered, 469–471

unordered, 467–468

clustered index seek, 473–475

clustering

active/active clusters, 660–661

active/passive clusters, 660

alternatives to, 656–657

backing out of, if upgrade fails, 665

compared to database mirroring, 584

configuring DTC for, 679–680

definition of, 654

failover clustering

backup and recovery for, 606

definition of, 584

handling, 694–695

log shipping integrated with, 648

process for, 659–660

support for, by SQL Server edition, 15

upgrading, 72

hardware requirements, 667–669

installing admin tools on remote cluster nodes, 48

limitations of, 655

maintaining, 692–696

Microsoft Technical Support for, 699

multinodes clusters, 661–662

multiple instances on same server, 662

network infrastructure requirements, 666–667

nodes for, 654, 657–658

nodes for, number to use, 661–662

patches for, 695–696

preparation for, 653–654, 666–669

private network for, 659

public network for, 659

quorum for, 658–659

reasons to use, 654, 655–656

rebuilding, 664–665

requirements for, 655–656

service packs for, 695–696

shared disk array for, 658

SQL Server clustering

checking with Cluster Administrator, 688–689

installing, 680–688

installing on multiple nodes, 690

testing, 690–692

SSAS clustering, 688

testing, 696

third-party clustering solutions, 657

troubleshooting, 697–699

upgrading to SQL Server 2005, 662–665

virtual cluster name and IP address for, 659

Windows 2003 clustering

configuring, 676–677

creating resource group, 677

installing, 670–676

preparing for installation, 669–670

testing, 678–679

CMP (Cellular Multiprocessing), 395–396

code page, 24–27

coherency, cache, 397

collation, 24–27

column-level permissions, 318–319

column statistics, 476–477

Common Language Runtime (CLR) integration

application domains and, 273, 274–275, 289–290

assembly for

altering, 285

catalog view of, 286

creating, 277–280

deploying, 280–286

dropping, 285–286

loaded, listing, 291

registering, 282–285

security for, 281–282

cataloging objects in, 286–289

configuring, 80

default settings for, 75

enabling, 79, 276–277

extended stored procedures compared to, 276

features for, 12

memory usage of, 291

performance monitoring for, 290–292

scalar function, 287–288

SQL Server as .NET runtime host, 273–274

stored procedures, catalog view of, 287

support for, by SQL Server edition, 14

T-SQL compared to, 275

Table Valued Functions, 288

trigger, 287

user-defined aggregates, 288

user-defined types, 288–289

community technology preview (CTP), 53

compilation of query

algebrization, 439, 447–448

definition of, 439, 442–443

normalization, 439

optimization, 439, 448–453

parsing, 439, 447–448

reasons for, 443–445

recompilation scenarios, 445–446

compressed drives, databases on, 65

configuration. See also Management Studio

default settings after installation, 77

displaying current configuration, 89

post-install configuration, 39–44

sp_configure procedure

activating AWE, 393

allow updates option of, 64

changing and overriding settings, 89–90

displaying current configuration, 89

for SQL Server Agent, 123–127

Surface Area Configuration (SAC) tool

accessing, 74

enabling CLR integration, 276

for Features, 40, 75–76, 79, 80–81

remote configuration with, 79

for Services and Connections, 39–40, 75, 79

Configuration Manager

compared to Services applet, 78

configuring SSIS using, 153

Network Configuration node, 41–42, 78

Services node, 28, 40–41, 78

:CONNECT command, 333–334

CONNECT permission, for Service Broker objects, 256–257

connections

configuring

with Management Studio, 88

with Surface Area Configuration, 39–40, 75

creating for projects, 322

protocols for, configuring, 75, 78

remote, enabling, 39–40, 75, 79

context switching, 312–314, 399

contracts, in Service Broker

creating, 216–217, 225

definition of, 216

mapping to service, 221

conversation groups, in Service Broker, 240–242

core, in multi-core system, 351

CPU

affinity mask, 397–398

cache, 349–350

coherency of cache, 397

context switching, 399

data locality, 396

hyperthreading, 345, 348–349

optimization considerations for, 395–401

performance considerations for, 345

processors, types of, 347–348

CPU node, 392

CREATE ASSEMBLY statement, 280–281

CREATE CERTIFICATE statement, 316

CREATE CONTRACT statement, 216–217

CREATE CREDENTIAL statement, 302

CREATE ENDPOINT statement, 243, 246, 250, 551

CREATE INDEX statement, 482, 483

CREATE LOGIN statement, 300

CREATE MASTER KEY statement, 315–316

CREATE MESSAGE TYPE statement, 214–216

CREATE PARTITION FUNCTION statement, 385

CREATE PARTITION SCHEME statement, 386

CREATE QUEUE statement, 219–221, 236

CREATE ROLE statement, 306

CREATE ROUTE statement, 248–249

CREATE SCHEMA statement, 307–308

CREATE SERVICE statement, 221–222

CREATE SYMMETRIC KEY statement, 316

CREATE TABLE statement, 386–387

CREATE TRIGGER statement, 324

CREATE TYPE statement, 9

CREATE USER statement, 306

CREATE_DATABASE events, 329

credentials

mapping SQL Server account to Windows account, 302

for SQL Server Agent proxies, 121

CTP (community technology preview), 53

cubes, partitioned, support for, 14