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