Index_C

C

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




SQL Server 2000 for Experienced DBAs
ppk on JavaScript, 1/e
ISBN: 72227885
EAN: 2147483647
Year: 2005
Pages: 126

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net