|
|
C++, creating programs in, 176
Cache
flushing, 236
how SQL Server is using, 459
Cache hit ratio, 189
Cached stored procedures, troubleshooting, 235-236
Caching data, 309
Caching registry data, 125
CAL (Client Access License) licensing model, 14
CASCADE command, 62
Catalog-level metadata, viewing, 323
CDO (Microsoft Collaborative Data Objects), 99
CDW (Copy Database Wizard), 20
CE Edition (SQL Server), 11, 444-447
Centralized administration, 112-114
Change management, 52-58
Changes, auditing, 73
Char data type, 226, 228
Char fields, 228
Character data in double-quotes, 245
Character data types, 226, 228
Character sets, listing available, 460
CHECK constraints, 326, 330-331
Client Acceptance Lab environment, 53
Client for Microsoft Networks, 7
Client Network Utilities program, 214-215
Cluster
account for, 405
disk data drive for, 404
failed installation of, 406-407
joining, 395
post-installation, 407-412
private connection for, 393-394
public connection for, 393
troubleshooting, 413-414
viewing servers participating in, 397
Cluster Administrator, 396-398, 407-412
after complete installation, 408
after resource group configuration, 401
before configuring resource groups, 397
Cluster configuration
minimum recommended, 375
minimum supportable, 374
Cluster Definition screen, 405
Cluster Disk Selection screen, 404
Cluster disk (Windows), selecting, 392
Cluster group owners and priority, setting, 400
Cluster groups
creating, 399
deleting empty, 400
planning, 398-399
Cluster IP address and network, setting, 395
Cluster logs, 413
Cluster name (Windows), assigning, 390
Cluster node, 371
Cluster server instance owners, defining, 405
Cluster Service Configuration Wizard, 388-397
Add or Remove Managed Disks screen, 391
Cluster File Storage screen, 391-392
Cluster IP Address screen, 395
Cluster Name screen, 389-390, 395
Create or Join a Cluster screen, 389-390
Hardware Configuration screen, 389
Internal Cluster Communication screen, 394
Network Connections screen, 392-393
Select an Account screen, 390-391, 397
starting, 388
Clustered indexes
on identity columns, 227
where to place, 253-254
Clustering, 381-418
domain considerations, 380
drive configuration for, 382
failover clustering, 371-380
high price of, 345
partitions for, 383, 386
preclustering considerations, 378-380
preparing drives for, 382-387
service pack installations and, 415-418
SQL Server 2000, 26-27, 371-372, 401-412
Windows 2000 Advanced Server, 387-401
Clustering configuration diagram, 373
Clustering options and their redundancy levels, 347
cnfgsvr.exe, 8
Code pages, listing installed, 488
Collation Compatible option (linked server), 310, 312
Column names, 223, 245
Column space
added by replication, 429
minimizing wasted, 230-231
Column-level metadata, viewing, 324
Column-level security, 67-70
Columns (database table)
added to each table for replication, 429, 450
checking for duplication, 234
disallowing NULLS on, 227
listing all, 469
COM mailing programs, 99
COM objects
all columns sharing one object, 126
creating, 203
comclust.exe, 402
Command Parser, 6
Command-line methods of executing SQL, 166-168
Command-line programs, executing, 178-179
Commands tab (Table Article Properties), 440-441
Company standards, documenting, 222
Compatibility levels (database), 45, 244, 319, 338
Compressed drives, 14
Computer Name screen, 402-403, 416
COM-structured file, saving a package as, 117
Configuration files (Query Analyzer), 168
Configuration option settings, listing, 461
Configuration options (SQL Server), 28-38
Configuration settings requiring a restart, 28
Configure Publishing and Distribution Wizard, 433
Conflict resolver priority code, 449
Conflict resolvers, 445-446, 449
Connection tab (SQL Server Agent), 102
Connections, managing, 31-32
Connections tab (Properties dialog box), 31-32
Connectivity, replication and, 421
Constraints in a database, list of, 470
Convert statements, used by hackers, 87
Copying data files, 295
Correctable errors, 135
Corrupt database
avoiding, 42
conditions for, 187
fixing, 187-189
Corrupt master database, recovering, 292
count() function, 207-208
Counters (System Monitor), 138-141
adding, 139-141
tracking, 141
worth watching, 142-145
Counting records, 207-208
CPU, debugging performance problems of, 257
CPU logging, for easy line-item billing, 26
CPU use, managing, 31
CPUs per instance, 340
Create Partition Wizard, 384-385
Create Publication Wizard, 438-439
CREATE VIEW command WITH SCHEMABINDING clause, 336-337
CROSS JOIN query, 232-234
C2-level auditing, 73-75
setting, 38
space issues with, 74
turning on, 73
Cumulative security, 62
Cursors
avoiding using, 241
simplifying, 172-176
Custom stored procedures, creating, 175-176
Custom templates, creating, 171-172
|
|