|
|
 |
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, 590–91
extracting data using BCP 592
loading data interactively 587–89, 587–88
loading data with command-line options 589
optional parameters 584–86, 584–86
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, 546–47
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, 594–95
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, 590–91
extracting data using BCP 592
loading data interactively 587–89, 587–88
loading data with command-line options 589
optional parameters 584–86, 584–86
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
Last Updated: Friday, July 6, 2001 |