Training
Certifications
Books
Special Offers
Community



 

Index


Special Characters and Numbers
* (asterisk) wildcard character  295
@ (at) symbol
    at the beginning of a variable name  395
    in a local variable  332
    preceding a parameter name  517
    preceding a variable name  395, 520
% Disk Read Time counter  136
% Disk Time counter  136, 142
% Disk Write Time counter  137
" " (double quotation marks)  159, 307
= (equality) operator  306
> (greater than) operator  306
>= (greater than or equal to) operator  306
% Interrupt Time counter  129
< (less than) operator  306
<= (less than or equal to) operator  306
<> (not equals) operator  306
!= (not equal to) operator  306
!> (not greater than) operator  306
[^] (not in range) wildcard character  309, 310
!< (not less than) operator  306
% (percent symbol) wildcard character  309
. (period)  960
# (pound symbol)  304, 305
## (pound symbols)  304, 305
% Privileged Time counter  129, 141
% Processor Time counter  129, 141, 142, 1000
    displaying in the Performance window  990
    displaying in the System Monitor window  991
[] (range) wildcard character  309, 310
@@ROWCOUNT system variable  481
%Systemroot% folder  152
% Total Interrupt Time counter  130
% Total Privileged Time counter  130
% Total Processor Time counter  130, 142
% Total User Time counter  130
@@TRANCOUNT system variable  477–78
_ (underscore) wildcard character  309, 310
% User Time counter  129, 141
/3GB flag in Windows NT 4 Enterprise Edition  811
10BaseT network   692
10BaseT technology  242
85 percent usage rule  132
100BaseT network  692
100BaseT technology  242

A
abstract logical elements in a cluster configuration  254
Access Methods object counters for  1031–32
access point to the data  131–32
Account Is Sensitive And Cannot Be Delegated option  955
Account Is Trusted For Delegation option  955
ACID properties  468–72
active/active cluster configurations  267
active/active clusters  262–63, 263, 268
active/active mode  267
Active Directory  25, 30–33
    architecture of  30–31
    benefits of  32–33
    hierarchical structure of  31, 31
    security related options  955
Active Directory tab of the SQL Server Properties window  1029, 1029
active/passive clusters  261–62, 262, 267, 268
active/passive mode  267
Active Server Pages  See ASP (Active Server Pages)
active transactions  477–78. See also transactions
Active Transactions counter  1035
ActiveX Data Objects  See ADO (ActiveX Data Objects)
Add Counters dialog box  989–90, 989
Add Members dialog box  954–55, 954
Add Network Library Configuration dialog box  237, 237
Add Printer wizard  22
Address Windowing Extensions (AWE)  6–7, 1014
Address Windowing Extensions API (AWE API)  811–12
Add Role Members dialog box  950–51, 951
administration and deployment features of Windows 2000  22–25
administration enhancements in SQL Server 2000  10–12
administrative functions  32
administrative tasks
    automating  837
    scheduling in a maintenance plan  824
ADO (ActiveX Data Objects)  570
ADO connection objects  571
advanced parameters  1019
Advanced tab of the New Job Step dialog box  842–43, 843
advertisement of resources in Active Directory  30
affinity mask parameter  1007–8, 1013–14, 1020, 1023, 1023
AFTER triggers  541, 543, 557
Agent History option
    for Merge Agent  758, 759
    for replication agents  685
agent login account  645, 648
Agent Profiles option
    for Merge Agent  759, 759
    for replication agents  685
Agent Properties option
    for Merge Agent  759, 759
    for replication agents  685
    selecting  665, 666
agents  684, 684. See also replication agents
Agents folder  683, 757, 758
aggregate data  771–72, 773
aggregate functions  317, 330–32, 444
    scalability and  68
    in the SELECT and HAVING clauses  320
    WHERE clause and  322
aggregate information  436
aggregate operation  969
aggregates
    selecting option ways of creating  798, 799, 800, 800
    updating  804
aggregations
    created by Analysis Services  775
    viewing  805, 806
aggregation views  443–44
alerts  856–59
    creating  666, 667, 859–65
    enabling/disabling  860, 860
    firing for performance conditions  857
    naming  860, 860, 863, 863
    reporting information about  282
alias data types  See user-defined data types
aliases
    creating for physical devices  887
    providing to SQL Server login accounts  931
Alias tab of the SQL Server Client Network Utility dialog box  237
all/column/index parameter with UPDATE STATISTICS  426
ALL keyword
    with aggregate functions  331
    with GROUP BY  319–20
    with UNION  328
Allow Anonymous Subscriptions screen in the Create Publication Wizard  662, 662, 708, 709
Allow Nulls heading in the Design Table window  381, 382
allow updates parameter  1014, 1020, 1026
ALTER DATABASE command
    changing the default filegroup  181
    new options for files and filegroups  285
    SET RECOVERY BULK_LOGGED  881
ALTER PROCEDURE statement  536–37
ALTER TABLE command  278, 337
    ADD CONSTRAINT  360, 375
    adding a new column  361
    adding a PRIMARY KEY constraint  374
    adding a UNIQUE constraint to an existing table  372
    adding columns  340–41
    altering a CHECK constraint  380, 380
    changing both data type and nullability  340
    changing or adding a DEFAULT definition on a column  359–61
    DROP CONSTRAINT  360, 375
    dropping a PRIMARY KEY constraint  375, 375
    dropping columns from a table  342
    enabling or disabling triggers  565
    modifying a FOREIGN KEY constraint  377–78, 378
    storing the DEFAULT definition with the table  358
    WITH NOCHECK option  378
ALTER TRIGGER statement  563–64, 563
ALTER VIEW command  456
American National Standards Institute. See ANSI
Analysis Manager  772, 787
Analysis Manager option in the Analysis Services submenu  780
Analysis Manager window  786, 786, 787, 787, 802, 802
Analysis Services folder  802
Analysis Services  771
    components of  772
    connecting to a SQL Server database  781
    installing  777–80
    overview of  771–77
    using the services provided  781–806
Analysis Services server  771
AND operator  307, 307, 308, 308
anonymous authentication  572
anonymous subscribers  662 662, 708, 709
ANSI  277
    automatic conversion to OEM character sets  237
    standards for SQL  277
ANSI NULL default option  582, 582
ANSI nulls database option  315–16, 339
ANSI Nulls option  159
ANSI SQL standard  277
API layer for SQL Server  229–30
APIs  231–33
append mode for backups  899
Append Output To Step History check box  842, 843
AppleTalk net-library  230
AppleTalk network protocol  240
application code page faults  117
application logs  1005
applications  3
    allowing selected to fail over  265
    architecture of  66–68
    bottlenecks caused by  1006
    cluster-aware  266
    communicating with SQL Server  514
    components of  66
    connecting Internet-enabled to SQL Server  569–72
    designing  65–68
    development by the SQL Server DBA  46
    failure of  877
    restarting with MSCS  266
    running on MSCS systems  260
    with SQL Server databases  56–58
application server  3, 4
application services component of an application  66
application simulation benchmark  108
architecture
    of applications  66–68
    backup-and-restore  285
    client/server  108
Argument information  964
arguments in a SELECT clause  294–95
armature in a disk drive  72, 73
Article Defaults button on the Specify Articles screen  656, 656
Article Issues screen in the Create Publication Wizard  748
Article Properties window  745–46, 746, 747
articles  638
    in replication data  639
    specifying  655–58, 656, 704–5, 704
    specifying the names of  745, 746
    specifying the objects to be replicated as  744–45, 745
ascending order  322
ASC keyword  322
AS keyword  303
    adding a heading to a summary column  318
    in a SELECT statement  297
ASP (Active Server Pages)
    accessing SQL Server  574–75
    advantages over CGI applications  575
    enhanced performance in Windows 2000  28
.asp extension  574
asterisk (*) wildcard character  295
Asynchronous Transfer Mode (ATM)  230
atomicity of transactions  468
“at” symbol (@). See @ (at) symbol
attributes
    in Active Directory  31
    changing for columns  225, 226
    defining additional on articles  745–47
audit level  930–31
audit trails  119, 133. See also log area
authentication
    enhancements in SQL Server 2000  777
    method  645
    options  572
    type  600 601
    in Windows NT  600, 601, 783, 783
Authentication area in the SQL Server Login Properties window  932, 932
authentication mode  See also Windows Authentication
    for accessing SQL Server  928–31
    selecting  937, 937
    setting up in Enterprise Manager  930–31
    specifying  712, 783, 783
Authentication Mode screen  149, 149, 151, 271, 272
Authentication With SQL Server screen  938
Authentication With Windows NT screen  938
autocommit mode  473
AutoComplete in Internet Explorer   5.01, 30
Auto Create Statistics check box  582, 582, 818, 818
automated-backup plan  830
automated teller machine (ATM) system  110
Automatically Grow File check box  194, 822
automatic checkpoints  823–24, 1009–10
automatic file growth  185–86
    compared to proportional filling  185
    configuring  822–23
    selecting  191
automatic restart in Windows   2000, 25
automatic rollbacks  480
automatic statistics updating  821
Auto-Param Attempts/sec counter  1040
auto-parameterization  1040, 1041
Autorun.exe program  269
Auto Shrink option  582, 582
Auto Update Statistics option  818, 818
auxiliary database structures  435
available disk space predictive analysis  138
available memory  122–23
Available Memory counter  121, 142
Average Latch Wait Time (ms) counter  1037
average latency  75
average seek time  75
Average Wait Time (ms) counter  1037
Avg. Disk Queue Length counter  137, 1004
Avg. Disk Read Queue Length counter  137
Avg. Disk Sec/Read counter  129, 1004
Avg. Disk Sec/Transfer counter  1004
Avg. Disk Sec/Write counter  129, 1004
Avg. Disk Write Queue Length counter  137
AVG function  330
AWE (Address Windowing Extensions)  6–7
AWE API  811–12
awe enabled parameter  7, 812, 1014, 1020
AWE Lookup Maps/sec counter  1033
AWE Stolen Maps/sec counter  1033
AWE Unmap Calls/sec counter  1033
AWE Unmap Pages/sec counter  1033
AWE Write Maps/sec counter  1033

B
B-tree structure  399
backup-and-restore architecture  285
backup-and-restore information  201
backup and restore operations  44, 873–74
Backup area of the SQL Server Backup dialog box  890, 891
BACKUP DATABASE command  896
BACKUP DATABASE permission  946
Backup Device Location dialog box  888
Backup Device object counter for  1032
Backup Device Properties window  888, 888
backup devices  918
    creating  888
    monitoring  1032
    selecting a particular  916
    using multiple  907
backup disk directory  830, 831
backup files  830, 831
backupfile table  283, 904
backup jobs  895–96
BACKUP LOG command  896
BACKUP LOG permission  946
backup media
    rotating  908
    specifying the number of days retained  1016
    verifying the integrity of  902
backup operations  38, 907
Backup/Restore Throughput/sec counter  1035
Backup/Restore Wizard in Windows 2000  21
backups  839, 873–74, 890–96. See also full backups
    describing  891, 901, 901
    displaying a percentage completed message  898
    documentation of  908
    improving the performance and execution of  907–8
    managing  895–96, 904
    methods for  885–87
    naming  891, 901, 901
    performing  887–904
    planning  906
    plans for  830, 830, 906
    scheduling  893, 905–6
    selecting the type of  891, 902, 902
    specifying passwords for  898
    splitting over multiple LAN segments  907
    staging  907
    storing off-site  908, 924
    terminology  873–75
    tracking  904
Backup Set Properties window  915, 915
backup sets  918
    specifying expiration rates  898
    specifying text descriptions of  898
Backup Set Will Expire option  894, 895
backup staging area  924
BACKUP statement  285
    examples of  899
    options for  898
    syntax of  896–99
backup table  549
Back Up The Database As Part Of The Maintenance Plan check box  830
Backup Verification And Scheduling screen  903, 903
balanced systems  99
bandwidth problems  246
bank transactions  625–26
Banyan VINES net-library  230, 240
basic authentication  572
batch (.bat) files  152–53
batch processing systems  57
Batch Requests/sec counter  1040
batchsize parameter for BULK INSERT  594
batch_size parameter with the BCP command  584
battery backup for write caching  80
BCP (Bulk Copy Program)  579, 583, 586–92
BCP batch size  768
BcpBatchSize parameter for the Merge Agent  763, 763
BCP command
    CHECK_CONSTRAINTS hint with  585
    compared to BULK INSERT  593
    extracting data interactively  590–92, 59091
    extracting data using BCP  592
    loading data interactively  587–89, 58788
    loading data with command-line options  589
    optional parameters  584–86, 58486
    queryout option  592
    required parameters  583–84
    specifying the character data type  584
    syntax of  583–86
BCP definitions  584
BCP operation  882
BCP threads  690–91
“before” images  119, 133
BEGIN DISTRIBUTED TRANSACTION command  631
BEGIN TRANSACTION statement  474
“behind the sharing” cache  256
benchmarks
    in the 1970s  107
    in the 1980s  107–8
    current  108
beta versions of software  877
BETWEEN clause with the HAVING clause  321
BETWEEN keyword  311–13
Bicycle_Inventory table  335–36, 336, 54647
Bicycle_Sales table  335–36, 336
bigint data type  10, 208, 284
binary data type  208
binary strings  284
Bind Columns button
    in the Default Properties window  368, 368
    in the Rule Properties window  396, 396
Bind Default To Columns dialog box  369, 370
Bind Default To User-Defined Data Types dialog box  368, 369, 370
Bind Rule to Columns window  396
Bind UDTs button
    in the Default Properties window  368, 368
    in the Rule Properties window  396, 396
bit data type  208
bitmap variable  1013
blocked processes  999
blocking  487
blocking status  995
blocks in cache  119
BLOCKSIZE option  898
bookmark lookup  966–67
Books Online option  780
Boolean expression  504
bottlenecks  988, 1000–1006
Bound Columns list  368, 369
branch nodes  400, 401
BREAK keyword  507
Browse Data option in the Analysis Manager window  805, 806
B-tree structure  399
buffer cache  810. See also cache
    monitoring  1033–34
    number of reserved pages in  1034
Buffer Cache Hit Ratio counter  1002, 1033
Buffer Manager object  1033–34
buffer pool
    monitoring the pages in  1034
    specifying the amount of memory for  1008–9
built-in data types  See system data types
BULK_LOGGED recovery mode
    restoring a database in  913
    setting the database to run in  881–82
bulkadmin role  953
bulk copies  580–82
BULK COPY operation  882
Bulk Copy Program  See BCP (Bulk Copy Program)
Bulk Copy Rows/sec counter  1035
Bulk Copy Throughput/sec counter  1035
BULK INSERT command  579, 593
    creating a script  605
    optional parameters  594–95, 59495
    required parameters  593–94
    specifying constraint checking for  594
    syntax of  593
    using  595–96, 595, 596
bulk update lock mode  486, 997
bus failure  876
business systems  56
Buzen  107
Bytes/Sec Through Network Interface performance counter  139

C
C2 audit mode parameter  1014, 1020
cabling for internal RAID  258–59  259
cache  See also buffer cache; controller caches; database cache; log cache; procedure cache; write caching
    block size  119
    data  879
    disabling internal  257–58
    faults  119, 121
    hit rate  119, 1002
    hit ratio for the SQL Server data cache  1000
    monitoring the amount of  1002
    size  119
Cache Faults/sec counter  121
Cache Hit Ratio counter  1035
Cache Manager object  1035
Cache Object Counts counter  1035
Cache Pages counter  1035
Cache Use Counts/sec counter  1035
caching
    controllers  79–80, 734
    fault tolerance and  259
    system  1001
calculated member  803
Cancel Executing Query button in the SQL Query Analyzer window  961
candidate key  375
capacity monitoring  48
capacity planning  40, 105. See also sizing
    basic counters for  142–43, 142
    for the disk subsystem  131–38
    history of  107–8
    for memory  118–23
    for the network  138–40
    principles of  111–17
    for the processor  123–31
    types of  105–7
capacity requirements in an SLA  59
Cascade Delete Related Records check box  389
Cascade Update Related Fields check box  389
CASCADING clause
    with ON DELETE  9
    with ON UPDATE  9
cascading deletes  558
CASE keyword  508–11
case-sensitive sort order  310–11
CAST function  312
catalog  402 420
catastrophic system failure  876
categories for jobs  840, 845, 846
CD Key dialog box  147, 150
cell security features  777
certification of device drivers in Windows 2000  18
certification process for Datacenter Server  16
chain blocking  487, 487
challenge/response authentication  572
ChangesPerHistory parameter for the Merge Agent  763, 763
change tracking  9–10
character data strings  284
character data type  584
character format  655  704, 744
character strings  306–7
char data type  208, 338
chart view in System Monitor  989, 989
CHECK constraint  379–81
    creating  392–94
    deleting  394
    enabling and disabling a  380–81, 381
    modifying  394, 394
CHECK_CONSTRAINTS hint with the BCP command  585
check_constraints parameter for BULK INSERT  594
Check Constraints tab of the Properties window  392–94, 393, 394
Check Existing Data On Creation check box  388, 392, 393, 394
CHECKIDENT command  1043
CHECK keyword in an ALTER TABLE statement  379
Check Media Set Name And Backup Set Expiration option  894, 895
Checkpoint Pages/sec counter  1033
checkpoints  815, 883–85
    determining how often to perform automatic  1009–10
    intervals for  883–85
    issuing manually  823
    log records  883
    operations  267–68, 823–24
    processes  883, 1033
    specifying the frequency of  1018
CHECKPOINT statement  823
checkpoint thread  879
Check Syntax button in the Stored Procedure Properties window  528, 528
CheckUnitPrice stored procedure  524
Choose A Data Source screen in the DTS Import/Export Wizard  597–98, 597, 606, 606
Choose A Destination screen in the DTS Import/Export Wizard  600, 601, 606, 607
Choose Destination Database screen
    in the Pull Subscription Wizard  674, 675, 716, 717
    in the Push Subscription Wizard  680, 681, 722, 723, 752, 753
Choose How You Want To Create The Dimension screen in the Dimension Wizard  792, 792
Choose Publication Database screen in the Create Publication Wizard  653, 654, 699, 700, 742, 743
Choose Publication screen in the Pull Subscription Wizard  672, 673, 715, 716
Choose Subscribers screen in the Push Subscription Wizard  679–80, 680, 722, 722, 752, 753
chunks  84
clean buffers  1044
Client Access Licenses  149, 272
client files  161
Client Network Utility
    managing the net-library layer  233
    starting  235–38
clients
    options for licensing  272
    placing requests into a pool  4–5
client/server architecture  108
client/server system  3–5
client-side script components in ASP  574
client utilities  153
cluster administration  47
Cluster Administrator software  251, 252
cluster-aware applications  260, 261, 266
cluster configuration  266–73
clustered indexes  406–7, 406, 408
    created by default for primary keys  373
    dropping  424
    enhancing performance when re-creating  416
    retrieving data in index-sorted order  406
clustered systems  250, 263–66
clustered table  407
cluster failover  63
clustering
    in data mining  776
    installing SQL Server for  268–73
    in a SAN  82
cluster management
    applications  260
    software  253–54
Cluster Management screen  270
cluster objects  251
clusters  249, 253–60
Cluster Services  27
cluster support in Microsoft Message Queuing  622
cluster-unaware applications  260, 261
.cmd file  290
CNVT status for a lock  997
code_page parameter  585
codepage parameter for BULK INSERT  594
Code Page Selection screen  157
collision lights on network hubs  1005
collisions
    in Ethernet networks  243
    monitoring on a network  245
column aliases in select lists  296–98
column constraint  370, 372
column delimiter  599
Column Mappings  602 602, 603
column properties  350–51  351
columns
    adding in Enterprise Manager  347, 347
    adding with T-SQL  340–41
    altering in Enterprise Manager  344–46
    altering with T-SQL  337–40
    default definitions for  358
    defining default values for  220
    defining for tables  224–25, 225
    dropping in Enterprise Manager  347–48
    dropping with T-SQL  342
    effects of altering  351–52
    excluding from replication  660, 661, 707, 707
    explicitly converting  312
    filtering  660, 706, 706
    gathering statistics on a combination of  819
    maximum number allowed in a composite index  403
    maximum number a view can reference  437
    minimizing for indexes  432
    renaming with T-SQL  342–43
    reordering in an index  413–14, 414
    restricting values to specific  379
    restrictions on altering  337
    restrictions on dropping  342
    selecting for views in the Create View Wizard  450, 450
    selecting those defining numeric measures of the cube  790, 791
    specifying as identity columns  222–23
    specifying in table aliases  303
    views consisting of a subset of  438–39
    views consisting of one or more  436
    for which a value will be provided  497
Columns tab
    in the Design Table window  365, 366
    in the New Table window  225, 226
column statistics  817. See also statistics
column values  495–97
COM+ application services  5, 618, 619
COM+ specification  618
command-line OSQL  231
command-line SQL  200
commands
    ALTER DATABASE command  181, 285, 881
    ALTER TABLE command  337
        ADD CONSTRAINT  360, 375
        adding a new column  361
        adding a PRIMARY KEY constraint  374–75, 374
        adding a UNIQUE constraint to an existing table  372
        adding columns  340–41
        altering a CHECK constraint  380, 380
        changing both data type and nullability  340
        changing or adding a DEFAULT definition on a column  359–61
        DROP CONSTRAINT  360, 375
        dropping a PRIMARY KEY constraint  375, 375
        dropping columns from a table  342
        enabling or disabling triggers  565
        modifying a FOREIGN KEY constraint  377–78, 378
        storing the DEFAULT definition with the table  358
        WITH NOCHECK option  378
    ALTER VIEW command  456
    BACKUP DATABASE command  896
    BACKUP LOG command  896
    BCP command
        compared to BULK INSERT  593
        extracting data interactively  590–92, 59091
        extracting data using BCP  592
        loading data interactively  587–89, 58788
        loading data with command-line options  589
        optional parameters  584–86, 58486
        queryout option  592
        required parameters  583–84
        syntax of  583–86
    BEGIN DISTRIBUTED TRANSACTION command  630–31, 631
    BULK INSERT command  579, 593–96, 605
    CHECKIDENT command  1043
    COMMIT command  624, 630, 630, 631
    CREATE DEFAULT command  358, 361–64
    CREATE INDEX command  415–16, 464, 882
    CREATE RULE command  395, 395
    CREATE STATISTICS command  819
    CREATE TABLE command  211, 211, 278, 336
        adding a CHECK constraint  379, 379
        creating a default on a column  359
        creating a PRIMARY KEY constraint  374, 374
        creating a table in a filegroup  219–20, 219
        creating a UNIQUE constraint  371–72, 371, 372
        horizontal partitioning  458
        storing the DEFAULT definition with the table  358
    CREATE TRIGGER command  547
    CREATE VIEW command  437–38
        accessing a subset of columns in a table  439
        accessing a subset of rows  440
        creating an aggregation view  444
        creating partitioned views  445
        joining tables into a virtual table  442
    DBCC commands  See specific entries under DBCC
    DISK INIT command  198
    DISKPERF command  1003
    DROP DATABASE command  201, 1044
    DROP PROCEDURE command  352, 537
    DROP TABLE command  278–79, 352, 504
    DROP VIEW command  352, 456
    entering in the New Job Step dialog box  842, 842
    GO command  294
    NET SEND command  865
    RECONFIGURE command  885
    RESET command  286
    RESTORE DATABASE command  918, 922
    RESTORE LOG command  918, 922
    SET IDENTITY_INSERT command  222
    SET IMPLICIT_TRANSACTIONS command  479
    UPDATE STATISTICS command  425, 426, 820
    USE command  211, 211
commit batch size  733–34
COMMIT command  624, 630, 630, 631
commit phase of the two-phase commit  624
committed data  469
committed transactions  475
COMMIT TRANSACTION statement  474, 475, 475
common objects section of Object Browser  973
communication layers in SQL Server  231
communications  41
Communications Manager  254
comparison operators  306–7, 321
Compatibility Level option  582
compatible data types  328
compatible locking hints  490
complete database backups  891
Completing The Configure Publishing And Distribution Wizard screen  650, 651
Completing The Create Database Backup Wizard screen  904, 904
Completing The Create Database Diagram Wizard screen  349
Completing The Create Database Wizard screen  192, 192
Completing The Create Index Wizard screen  413–14, 413, 414
Completing The Create Job Wizard screen  853
Completing The Create Login Wizard screen  939, 939
Completing The Create Publication Wizard screen  658, 664, 664
Completing The Create Stored Procedure Wizard screen  533–34, 533, 535
Completing The Create View Wizard screen  451
Completing The Database Maintenance Plan Wizard screen  832, 833
Completing The DTS Export Wizard screen  610
Completing The DTS Import Wizard screen  604
Completing The Pull Subscription Wizard screen  677, 678, 720, 720
Completing The Push Subscription Wizard screen  682, 683, 726, 726, 756, 757
Completing The SQL Server Full-Text Indexing Wizard screen  422, 422
Completing The SQL Server Upgrade Wizard screen  160, 160
Component Services  617–23
composite indexes  403–4, 403
    creating  412, 431
    order of  414
Computer Is Trusted For Delegation option in Active Directory  955
Computer Name screen  146, 150, 269, 270
CONCAT UNION hint  983, 983
concurrency  485
concurrent transactions  470
concurrent users  118
configuration  See also database configuration
    documenting  43, 923
    functions  972
    implementing  100–101
    options  813–14, 814
Configuration Database Manager  254
configuration parameters  See also parameters
    descriptions of  1013–19
    listing of  1019, 1020
    modifying  1007, 1021
    setting  1013–19, 1019–29
Configure Publishing And Distribution Wizard  643–51, 668
Configure SQL Server Agent screen in the Configure Publishing and Distribution Wizard  646, 646
conflict
    defining  745
    rows with a  740
conflicting locking hints  490
conflict resolver  See resolver
Conflicts/sec counter  1040
connectionless messaging  622
Connection Manager in ODBC  233
connection memory  811
Connection Memory (KB) counter  1038
connection objects  571
connection pool  232–33
connection pooling  4, 570–71
    effectiveness hampered by integrated security  571
    with named pipes  572
    software for  5
connections  5
Connections tab
    of the server’s Properties window  816, 817
    of the SQL Server Properties window  1025, 1025
Connection tab of the Data Link Properties window  789–90, 789
connectivity problems  241
Connect To SQL Server dialog box  287, 287, 960–61, 960, 976, 976
consistency of transactions  468
constraint checking  594
CONSTRAINT keyword  374
constraints  357, 370–94
    checking during bulk load  585
    creating and modifying with Enterprise Manager  381–94
    creating and modifying with T-SQL commands  370–81
    naming  379–80
    triggers and  543
    types of  370
consultant  46
CONTAINS keyword  316
CONTAINS predicate with a SELECT statement  423
Context Switches/sec counter  990, 991
context switching  1015
CONTINUE keyword in a loop  507
continuous mode for the Log Reader Agent  709, 711, 712
Continuous parameter for the Merge
Agent  761
continuous updates
    configuring for the Distribution Agent  724
    selecting for the Distribution Agent  718
controller caches  79–80. See also cache
    behind sharing  256, 256
    clustering and  255–56, 256
    “in front of” the sharing  255, 256
controllers
    spanning multiple  100
    spreading among available PCI slots  102
    spreading among PCI buses  82
controller write cache in a cluster configuration  258
CONVERT function  312
coordination of multiple data source transactions  623–24
corporate report  111
corrupted data  878
cost/space ratios for RAID levels  96
cost threshold for parallelism parameter  1014, 1020, 1023, 1023
COUNT_BIG function  330
counters
    selecting for monitoring memory  120
    in System Monitor  989
COUNT function  330, 331, 331
covering indexes  432, 981
covering queries  432
CPUs
    adding or replacing  1001
    bottlenecks caused by  1000–1001
    collecting usage data for multiple  130
    determining the number required  115, 126–28
    failure of  876
    monitoring the usage of  730
    selecting for SQL Server  1023
    selecting usage data for a single  129–30
    specifying for SQL Server threads  1007–8
    throttling in Windows 2000  28
CPU time
    calculating for read functions  127
    total used for processing writes  128
CPU utilization  106
    calculating  126
    calculating for read functions  127
    calculating over time  130–31, 131
    calculating total  128
    compared to response time  114–16, 115
    determining the percentage of  1000
    good target for  136
Create And Manage Publications dialog box
    configuring publications  741–42, 741
    configuring push subscriptions  720, 721, 751, 751
    configuring snapshot replication  652, 652
    configuring transactional replication  699
    selecting publications in  678–79, 679
Create A New Data Source To SQL Server dialog box  782–84, 783, 784
Create Database Backup Wizard  900–904
Create Database Diagram Wizard welcome screen  348, 348
CREATE DATABASE permission  946
Create Database Wizard
    creating databases  188–92
    Define The Database File Growth screen  191
    Define The Transaction Log File Growth screen  192
    limitations of  187
    Name The Database And Specify Its Location screen  189, 189
    Name The Database Files screen  190
    Name The Transaction Log Files screen  191–92
    welcome screen  189
CREATE DEFAULT command  358
    creating a Default object  361–63
    sp_bindefault and  361–64
CREATE DEFAULT permission  946
CREATE INDEX...DROP_EXISTING statement  425
CREATE INDEX command  415–16, 464, 882
Create Index Wizard  409–15
Create Job Wizard  848–53
Create Login Wizard  936–39
Create New Data Source dialog box  782
CREATE PROCEDURE permission  947
CREATE PROCEDURE statement  516–26
Create Publication button  699, 699, 741, 742
Create Publication Wizard  652, 699–709, 741–49
Create Relationship dialog box  391, 391
CREATE RULE command  395, 395
CREATE RULE permission  947


Next




Top of Page


Last Updated: Friday, July 6, 2001