filter event notifications 573
filtering in snapshot replication 660
filters for replication 639
Filters tab of the Trace Properties window 978, 978
Filter Table Columns screen in the Create Publication Wizard 660, 661, 707, 707
Filter Table Rows screen in the Create Publication Wizard 661, 661, 707, 708
Finish The Cube Wizard screen 796, 797
Finish The Dimension Wizard screen 796
Finish The Storage Design Wizard screen 801
firing order 543
firing triggers 541
first_row parameter 586
firstrow parameter for BULK INSERT 594
Fixed Field Column Positions screen in the DTS Import/Export Wizard 599
fixed-length data types 210–11
fixed server roles 953
flat schema See star schema
float data type 208
flow logic 843
folders 973
FORCE ORDER hint 984
Force Restore Over Existing Database check box 916
foreign key 375
foreign key constraint 354
foreign key constraint relationship in a database diagram 349
FOREIGN KEY constraints 375–79
adding to an existing table column 378
creating or modifying in Enterprise Manager 385–92
DELETE triggers and 547–48
deleting 548
enabling or disabling the use of 378–79, 379
modifying in Enterprise Manager 392
modifying with T-SQL commands 377–78
foreign key relationship
checking existing data against 388
creating at table creation time 386
creating between two tables 390–91
format_file parameter with the BCP command 584, 589–90
formatfile parameter for BULK INSERT 594
FORMAT option with the BACKUP statement 898
format parameter with the BCP command 584
formatted space vs. unformatted 99
Forwarded Records/sec counter 1031
FOR XML clause 8
fragmentation of indexes 417, 418
free lists 1034
Free List Stalls/sec counter 1034
Free Pages counter 1034
free space 827
FreeSpace Page Fetches/sec counter 1031
FreeSpace Scans/sec counter 1031
FREETEXT keyword 316, 423
FROM clause
in a DELETE statement 281
in a SELECT statement 293–94, 298–304
with UPDATE 500–502
From Device option 914, 914, 916, 916
full backups 885, 886. See also backups
planning for off-hours 905
restoring from 911–12
scheduling over several days 905
selecting 902, 902
full-disk seek 75
full outer joins 300
full population 421
FULL recovery mode 881
fullscan parameter with sp_createstats 820
fullscan parameter with UPDATE STATISTICS 426
Full Scans/sec counter 1031
full table scans 111, 819, 1031. See also table scans
full-text indexes 164, 408–9
creating with stored procedures 422–23
creating with the Full-Text Indexing Wizard 418–22
default language used by 1015
restrictions applying to 408–9
scheduling automatic updates to 421
Full-Text Indexing Wizard 418–22
full-text searching 9–10. See also Microsoft Search service
functions See T-SQL functions
futureonly option with sp_bindefault 362
fuzzy match 316
G
General Statistics object counters for 1036
General tab
of an agent’s Properties window 666
of the Database Maintenance Plan dialog box 834, 835
of the database Properties window 305
of the Database Properties window in Enterprise Manager 193
of the Default Table Article Properties window 656, 657
of the Edit Job Step dialog box 711
of the Linked Server Properties window 462, 462, 463
of the Log Reader Agent’s Properties window 710, 710
of a Merge Agent’s Properties window 760
of the New Alert Properties window 860, 860, 862, 863–64, 863
of the New Job Properties window 839–41, 839, 841
of the New Job Step dialog box 841–42, 842
of a new log file’s window 991
of the New Operator Properties window 866, 866
of the Restore Database dialog box 914, 915, 916
of a server’s Properties window in Enterprise Manager 814
of a service’s Properties window 621–22, 621
of the SQL Server Backup dialog box 890
of the SQL Server Client Network Utility dialog box 236–37, 236
of the SQL Server Login Properties window 932, 932
of the SQL Server Network Utility dialog box 234, 234
of the SQL Server Properties window 1021, 1021
of the Table Article Properties window 745, 746
of the Trace Properties window 976, 976
GETDATE function 332
GetUnitPrice stored procedure
altering 536–37, 536–37
creating 519, 519, 523, 523
dropping 537
ghosted records 1032
Gigabit Ethernet 242, 692
Giganet net-library 234–240
global cursors 514
global defaults 1019
globally unique identifiers See GUIDs (globally unique identifiers)
global temporary table 304
Global Update Manager 254
global variables 972, 973
GO command in command-line OSQL 294
GO keyword 211, 211, 286
Golden Rule 49
GOTO keyword 511
Grant Access To Databases screen in the Create Login Wizard 939, 939
Grant Access To Security Roles screen in the Create Login Wizard 938, 938
Granted Workspace Memory (KB) counter 1038
GRANT OPTION FOR option with the REVOKE statement 946
GRANT statement
adding permissions to roles 952–53
assigning object permissions 944–45
assigning statement permissions 948
EXECUTE with 537
GRANT OPTION keyword 945
GRANT status for a lock 997
granularity level of locks 484–85
graphical user interface (GUI) 21, 21
greater than (>) operator 306
greater than or equal to (>=) operator 306
Grid pane in the New View window 446
GROUP BY clause
adding in the New View window SQL pane 448
in a SELECT statement 317–20
with the UNION operator 328–29, 328–29
GROUP BY hints 982–83, 983
GROUPING function 330
Group Policy Editor 23
groups
including all 319–20
nesting with GROUP BY 318–19
growth increment 185
growth rate for systems 98
GUIDs (globally unique identifiers)
creating 283
retrieving values from 296
storing 284
GUI (graphical user interface) in Windows 2000 21, 21
H
hard disks See disk drives
hardware
documenting 36–37, 43, 923
evaluation 47
failures 250, 274, 876
interrupts 129
hardware-based RAID 79–82
hardware layer 240, 242–44
HASH GROUP BY hint 982, 983
HASH hint 981, 982
hash joins 981, 982
HASH UNION hint 983
HAVING clause
without a GROUP BY clause 322
in a SELECT statement 320–22
with the UNION operator 328
HBA (host bus adapter) 81
heartbeats 253–54, 763
help desk 47
heterogeneous data sources
configuring replication for 704
specifying for subscriber servers 744
hibernate mode 26
hierarchical storage management in Windows 2000 24
hierarchical structure of Active Directory 31
high availability
compared to “fault tolerant” 250–51
of MSCS 251
with static load balancing 263–64
high-availability cluster with static load balancing 264
hints 427, 981–84
specifying for bulk copy 585
types of 427–28
HistoryVerboseLevel parameter
for the Merge Agent 763, 763
in the Replication Agent Profile Details screen 712, 713
HOLAP (Hybrid OLAP) 798
HOLDLOCK locking hint 489
horizontal filter 639
horizontal filtering 660, 660, 706, 706
horizontal partitioning 458–59, 458
host bus adapter (HBA) 81
hot docking in Windows 2000 26
hot spare system 264, 265
HTTP requests and responses 573
human error 250, 274, 877–78
Hybrid OLAP (HOLAP) 798
I
identifier column 748 748
IDENTITYCOL expression in a select list 296
identity column 658
IDENTITY columns 373, 497
IDENTITY property
adding 222–23
not transferring to the subscriber’s table 658
IEAK (Internet Explorer Administration Kit) 24
IEC (International Electrotechnical Commission) 277
IF statement
ELSE clause 504–6
EXISTS clause 481
EXISTS...ELSE clause 481, 481
nesting 506
IF UPDATE clause in an UPDATE trigger 553
ignore_dup_key parameter with CREATE INDEX 416
IIS 5 (Internet Information Server 5)
application protection 18
CPU throttling 28
with Windows 2000 as an Internet platform 570
image data type 208
image filtering 10
immediate recovery 924
immediate-updating replication 702
immediate-updating subscriptions 702
implicit conversion 312, 328
implicit mode 479
implicit transactions 479
Import Wizard in DTS 596–605
incompatible data type errors 496
incremental population 421
increment value 222
INDEX = hint 984, 984
index create memory parameter 812, 1015, 1020
indexed-column statistics 817, 818
indexed views 464–65
indexes 399, 435
adverse impact of too many 980
analyzing 429
creating 409–23, 430–32
dropping and re-creating 827
effectiveness of 430
forcing the use of specified 984, 984
guidelines for 432
levels of 400, 401, 424
naming in the Create Index Wizard 413, 413
optimizing 980
rebuilding 424–26, 827
reindexing a table’s 1044
reordering columns 413–14, 414
scalability and 68
selectivity of 431
specifying a group of 427
specifying particular 427
statistics for 424, 425, 426
structure of 399–402
tasks best suited for 431
types of 406–9
uniqueness of 405
using 426–30, 432, 1006
for views 452
Indexes/Keys tab 382, 383
index hints 428, 966
indexing
concepts of 402–9
enhancements in SQL Server 2000 10
index keys 402
index node. See index pages
indexonly parameter with sp_createstats 820
index pages 399, 1015
index page split 416–17, 417
index rows 400
index scans 404–5, 1031
Index Searches/sec counter 1032
index space per data row 98
informational message 859
Infrared Data Association support 26
“in front of” the sharing cache 255
Initialize And Label Media option in the SQL Server Backup dialog box 894, 895
Initialize Subscription screen
in the Pull Subscription Wizard 674, 675, 717, 717
in the Push Subscription Wizard 682, 724, 725, 755, 755
initial size of a file 185
INIT option with the BACKUP statement, 898
IN keyword 313–16, 314
inner joins 299–300, 302
inner transactions 476
in parameter with the BCP command 584
input_file parameter 585
input parameters
specifying in a stored procedure 517–19, 517–18, 518–19
supplying default values for 518–19, 518
input values 520
inserted table 544, 545, 546
querying in an INSERT trigger 550, 550
querying in an UPDATE trigger 551, 551
InsertRows stored procedure
creating 520–21, 520–21, 526–29
viewing the statements used to create 538, 538
INSERT statement 279, 494–99
deleted table and 546
triggers with 541
INSERT trigger 541, 550–51, 550
Installation Definition dialog box 147
installation path 150
Install SQL Server 2000 Components dialog box 146, 147
Instance Name dialog box 147, 151, 270–71
instances of SQL Server 2000 7
INSTEAD OF trigger 541, 543, 554–57
in-store purchasing systems 56
instruction 129
int data type 208
integer data type 208
integrated security 571–72
integration with Active Directory in Microsoft Message Queuing 622
integrity See also data integrity
of the backup 830, 902
of databases 874
of a transaction 467
integrity checks 824, 828–29
IntelliMirror 20
intent exclusive lock mode 486
intent lock modes 486
intent shared lock mode 486
interactive mode for the BCP command 587–88
Interactive SQL for Windows See SQL Query Analyzer
internal latches 1037
internal RAID controllers 257–58, 257
internal RAID subsystem 257–58
internal RAID system 80, 81
International Electrotechnical Commission. See IEC (International Electrotechnical Commission), standards for SQL
International Organization for Standardization See ISO (International Organization for Standardization), standards for SQL
Internet
printing support in Windows 2000 30
programming languages supported by Internet Explorer 29
Internet-enabled applications 569–72
Internet Explorer 5.01, integrated in Windows 2000, 29
Internet Explorer Administration Kit (IEAK) 24
Internet Information Server 5. See IIS 5 (Internet Information Server 5)
Internet Information Services Manager console 29, 29
Internet Server API See ISAPI (Internet Server API)
Internet support component of Windows 2000 29–30
interoffice data sharing 740
interoperability
extended by Active Directory 33
with MSMQ 1 622
Interrupts/sec counter 130
% Interrupt Time counter 129
interviews 118
INTO clause for the SELECT statement 304–5
INTO keyword with the INSERT statement 494
inventory archive system 110
I/O bus 82
I/O capacity
configuring
for merge replication 766
for snapshot replication 687
for transactional replication 733
I/O-intensive systems 184–85
I/O latencies
experiencing long 1002
sensitivity of SQL Server to 96–97
I/O operations See also physical I/Os; sequential I/O
calculating for various RAID levels 125–26
for disk drives 1003
distributing random 78
as a function of latency 77, 77
isolating sequential 78
monitoring 102, 730
time required for 76
I/O performance 686–87
I/O requirements 97–99
I/O subsystems
bottlenecks occurring in 1002–5
concepts 79–84
configuring 71, 688, 733, 767
guidelines for 78
high-end 82
relation of memory to 1001
sizing 1003
splitting into multiple volumes 100
supporting clustering 256–60
tips and recommendations 102
tuning 731
IPSec configuration dialog box 19
IP Security dialog box 19
IrDA (Infrared Data Association) support in Windows 2000 26
ISAPI (Internet Server API) 570
accessing SQL Server 572–74
applications 572
extensions 572–73
filters 572, 573
limitations of 574
IS (intent shared) lock mode 997
IS NOT NULL keyword 313, 339
IS NULL keyword 313, 339
ISO (International Organization for Standardization) 277
isolation See levels of isolation
ISQL utility 285, 286
ISQL/W See SQL Query Analyzer
isqlw.exe 960
items table 493
IX (intent exclusive) lock mode 997
J
JBOD 256
Job Categories dialog box 845, 846
job clearinghouse 838
job history 854–56
Job Notifications screen in the Create Job Wizard 851–52, 852
jobs 838
categories for 840
creating 839–53
creating schedules for 843–44, 844
describing 840
disabling 853
displaying in a maintenance plan 833, 834
displaying in Enterprise Manager 895, 895
editing 854
enabling or disabling 840
grouping related 840
managing 853–54
managing categories for 845, 846
naming 840, 852, 853
naming for alerts 862, 862
notification process for 844–45, 845
owners of 840
retrying 842
scheduling on a recurring basis 850, 851
specifying schedules for 850, 851
starting 853, 854
stopping 853, 854
updating 854
job steps 841, 843
joined tables 299–303
join hints 981–82, 982
JOIN keyword 299
join operation 967–69
JOIN operator 967, 968
joins
SQL-92 syntax for 982
using staging tables for 612, 612
views consisting of 436, 442–43
JScript 575
K
KeepAliveMessageInterval parameter for the Merge Agent 763, 763
keepidentity parameter for BULK INSERT 594
keepnulls parameter for BULK INSERT 594
KEEP_REPLICATION option with RESTORE 921
Kerberos protocol 19
kernel-mode write protection in Windows 2000 18
KEY lock type 996
keywords
case sensitivity of 294
programming-construct 504–11
in search conditions 308–16
searching by groups of 408
kill process tree in Windows 2000, 25
KILOBYTES_PER_BATCH hint with the BCP command 585
kilobytes_per_batch parameter for BULK INSERT 595
“knee of the curve” theory 112–13
L
labels 894 895
language
default 1015
specifying for SQL Server messages 784, 784
LAN segments
backing up data to multiple devices over several 889
using multiple 907
last_row parameter
for BCP 586
for BULK INSERT 595
latches 1037
Latches object counters for 1037
Latch Waits/sec counter 1037
latency 1004
average 75
during random I/O 77
rotational 73–74, 74, 76
latent consistency 468
LateShipments stored procedure 516–19, 516, 518
layers 229
lazywriter thread 879
Lazy Writes/sec counter 1034
.ldf extension 180, 192
leaf nodes 400, 401–2, 401
least recently used (LRU) page list 879
Leave Database Nonoperational But Able To Restore Additional Transaction Logs option 917
Leave Database Operational. No Additional Transaction Logs Can Be Restored option 917
Leave Database Read-Only And Able To Restore Additional Transaction Logs option 917
left outer joins 301
less than (<) operator, 306
less than or equal to (<=) operator, 306
Level 2 (L2) cache size of CPUs 1001
levels of isolation 469
determining active 471–72, 471–72
setting 471–72
transaction behaviors allowed by 470, 470
levels of locking 484–85
licensing
per processor 149–50
per seat 149, 272
per server 272
Licensing Mode dialog box 149, 152, 272
lights on network hubs 1005
lightweight
pooling parameter 1008, 1015, 1020,
1023, 1023
LIKE keyword 309–11
preceding by the NOT operator 311
in the WHERE clause of a SELECT statement 423
linear CPU utilization predictive analysis, 131
linear growth 113
compared to exponential growth 113–14
of CPU utilization 113, 113
linear memory predictive analysis for available memory 122
linear page fault predictive analysis 123
linear trend 122–23
line capacity 139
linked-server definitions 459–61
Linked Server Properties window 462, 462, 463
literals 307
load operations 580
Load SQL Script button in SQL Query Analyzer 289
LOAD statement 285
Local Disk Properties screen 24
local installation of SQL Server 145–50
local named pipes protocol 239
local server
indicating a connection with a period (.) 960
running jobs on 841
LocalSystem account 648
enabling delegation to run under 956
remote systems and 889
local temporary table 304
local variables See also variables
declaring 520
setting within SELECT statements 332
within stored procedures 520–22
lockable resources 484
Lock Blocks Allocated counter 1038
Lock Blocks counter 1038
lock configuration 484
locked objects 997
lock information
viewing for an object 998, 998
viewing for SPIDs 996–97
locking
hierarchy 486
hints 488–90
levels of 484–85
management 483, 484
method 428
monitoring 999
Lock Memory (KB) counter 1038
lock modes 485–86, 997
Lock Owner Blocks Allocated counter 1038
Lock Owner Blocks counter 1038
Lock Requests/sec counter 1037
locks 483
allocating 1015
allocating and deallocating dynamically 814
monitoring SQL Server 993
status of 997
types 996
Locks object 1037
Locks/Object folder 997, 997
locks parameter 814, 1015, 1020
Locks/Process ID folder 996, 996
Locks/Process ID pane, SPIDs shown in, 995
Lock Timeouts/sec counter 1037
Lock Waits/sec counter 1037
Lock Wait Time (ms) counter 1037
Log agent startup message step 711, 711
log area 118–19
Log Bytes Flushed/sec counter 1035
log cache 811. See also cache
Log Cache Hit Ratio counter 1036
Log Cache Reads/sec counter 1036
log files 179
calculating the number of disk drives needed to support 133
configuring in Enterprise Manager 194
creating before starting the Upgrade Wizard 158
maximum file size for 180
saving performance data to 991
Log File(s) Size (KB) counter 1036
Log Files tab of a new log file’s window 991, 992
Log File(s) Used Size (KB) counter 1036
Log Flushes/sec counter 1036
Log Flush Waits/sec counter 1036
Log Flush Wait Time counter 1036
logging 878–85
changing settings for 858–59
reducing during bulk loads 580–82
Log Growths counter 1036
logical backup devices 887–89, 891, 892
logical database 64
logical devices 198, 887
logical disk 78, 84
LogicalDisk object counters provided by 1003
logical I/Os 126–27
Logical Operation information 964
logical operators 307–8, 307, 321
logical reads 134
logical read time 127
logical read utilization 127
login attempts 931
login audit level 930–31
login_id parameter 586
logins See also SQL Server, logins
managing 39
vs. users 931
Logins/sec counter 1036
LoginTimeout parameter 712, 713, 764
logo for Windows 2000 18
Logon screen of the SQL Server Upgrade Wizard 156
Log On tab in the SQL Server Agent Properties window 168
Logouts/sec counter 1036
Log Reader Agent 641–42, 695–96, 697
configuring 709–14
modes for 709–10
modifying the profile for 712
monitoring activity and latency of 735
reading transactions or commands from the transaction log 714
tuning 734–35
Log Reader Agent Profiles dialog box 713
Log Reader Agent’s Properties window 710, 711
Logreader: Delivered Cmds/sec counter 1039
Logreader: Delivered Trans/sec counter 1039
Logreader: Delivery Latency counter 1039
logs 1005
log shipping 11, 880, 911, 923, 925
Log Shrinks counter 1036
Log Truncations counter 1036
log writer thread 880
Look For Publications screen in the Pull Subscription Wizard 672, 673, 714, 715
LOOP hint 981
LRU page list 879
M
magnetic head in a disk drive 72
maintenance
documenting in the system log 44
routine 39
Maintenance History screen 832, 833
maintenance plans 824–25
creating 192, 825–33
creating reports with the results of 832
displaying the jobs in 833, 834
editing 834, 835
Make This A Clustered Index check box 413
Make This A Unique Index check box 413
manageability of MSCS 251
Manage Indexes dialog box 965, 965
Manage Indexes option in SQL Query Analyzer 12
Management folder in Enterprise Manager 175
Manage SQL Server Messages dialog box 861
Manage Statistics option in SQL Query Analyzer 12
manual memory management 810
many-to-one replication method for implementing transactional replication 736–37
MAPI-1-compliant e-mail client 865
mark 921
master database 186
master server for jobs 838
materializing a view result set 464
MaxBcpThreads parameter 691, 691
MaxDeadlockRetries parameter 764
max degree
of parallelism parameter 1016, 1020,
1023, 1023
MaxDownloadChanges parameter 764
max_errors parameter 585
maxerrors parameter for BULK INSERT 595
MAX function, 330, 331, 331
maximum availability 264, 265
Maximum Concurrent User Connections spin box 816, 817
maximum file size 185–86
setting 191, 822
specifying in Enterprise Manager 194
maximum seek time 75
Maximum Workspace Memory (KB) counter 1038
max server
memory parameter 812, 1008, 1016,
1017, 1020, 1022, 1022
MAXSIZE keyword with CREATE DATABASE, 195–96, 196, 197, 198
max text repl size parameter 1016, 1020
MaxUploadChanges parameter for the Merge Agent 764
max worker threads parameter 1016, 1020
setting in Enterprise Manager 1023, 1023
setting with sp_configure 1013
MCSC (Microsoft Certified Support Center) 16
.mdf file extension 180, 190
MDX Sample Application option in the Analysis Services submenu 780
mean time between failures (MTBF), 75, 84
measures 803
MEDIADESCRIPTION option with the BACKUP statement, 898
media expiration date 894, 895
media header, rewriting, 898
media integrity 894, 895
MEDIANAME option
with the BACKUP statement 898
with RESTORE 920
MEDIAPASSWORD option
with the BACKUP statement 898
with RESTORE 920
media retention parameter 1016, 1020, 1027, 1027
media set 920
member key columns 794, 795
member tables 458
memory
accesses 1001
allocation configuration parameters 812–13
amount accessible by SQL Server 811
amount of unused 121
bottlenecks caused by 1001–2
caches in disk drives 80
calculating the minimum required 119–20
capacity planning for 118–23
collecting usage data 120–21
counters for capacity planning 121
data 121–23
dynamic allocation of 1002, 1016
failure of 876
monitoring usage 810
pressure 121
settings for allocating 1022
sizing 116
specifying
amount for the buffer pool 1008–9
amount used for index creation sorts 1015
maximum amount for dynamic allocation 1016
minimum amount for query allocation 1016–17
support in SQL Server 2000 6–7
Memory Grants Outstanding counter 1038
Memory Grants Pending counter 1038
Memory Manager object counters for, 1038–39
Memory object in Performance Monitor 120
memory pool 810–11
Memory tab in the SQL Server Properties window 1009, 1022, 1022
memory usage
collecting data on 120–21
monitoring 810
Merge Agent 642
checking the status of 758
configuring 760–64
modifying the profile for 762–63, 762
options for monitoring and managing 758–59, 759
selecting the mode for 760, 761–62, 761
selecting where it will run 753, 754
specifying permissions necessary for merge replication 746, 747
tasks in merge replication 739–40
Merge Agent Profiles dialog box 762–63, 762
Merge Agent Properties window 760–61, 760, 761
Merge Agent Startup Message step 760, 761
merge batch size 767, 768
MERGE hint 981
Merge Publication option
in the Create Publication Wizard 654, 655
in the Select Publication Type screen 701
merge publications 741–49
merge replication 64, 638, 739–40. See also replication
attributes of 765–66
configuring 741–57, 766–67
counters for 1040
enabling for specific databases 648–49
enhancements of 12
monitoring 767–68
publication 743, 744
tuning 768
MERGE UNION hint 983
Merging Changes tab of the Table Article Properties window 746, 747
message backup and restore in Microsoft Message Queuing 623
message ID value (msg_id) 857
message passing
merge replication with 740
between systems using transactional replication 697
Message Queuing (MSMQ) 622–23
messages
changing the logging status of 857
creating with a severity level greater than 18 858
Messages tab of the Manage SQL Server Messages dialog box 861, 861
Messaging API 865
metadata 637, 775
Microsoft Certified Support Center (MCSC) for Datacenter Service 16
Microsoft Cluster Services See MSCS (Microsoft Cluster Services)
Microsoft Decision Tree 775–76
Microsoft distributed file system (Dfs) 24
Microsoft Distributed Transaction Coordinator. See MS DTC (Microsoft Distributed Transaction Coordinator)
Microsoft English Query 2000 Setup dialog box 780, 780
Microsoft Installer in Windows 2000, 18
Microsoft Internet Information Server. See IIS 5 (Internet Information Server 5)
Microsoft Management Console (MMC) 23, 168
Microsoft Message Queuing (MSMQ) 622–23
Microsoft Search service 164
Microsoft SQL Server 2000. See SQL Server 2000
Microsoft SQL Server 2000 Analysis Services See Analysis Services
Microsoft SQL Server database administrator. See database administrator
Microsoft Windows 2000. See Windows 2000
Microsoft Windows 2000 System Monitor. See System Monitor
Microsoft Windows Authentication See Windows Authentication
MIN function 330, 331, 331
minimal service times 58
Minimum installation 147, 148, 151
minimum memory 119–20
mining model 792, 792
min memory per query parameter 812, 1016–17, 1020, 1022, 1022
min server memory parameter 268, 812, 1009, 1016, 1017, 1020, 1022, 1022
mirrored caches in external RAID systems 259
mirroring 86, 91
Mixed Mode Authentication 928, 929–30
specifying 149, 151, 152, 271, 937, 937
Mixed Page Allocations/sec counter 1032
MMC (Microsoft Management Console) 23, 168
MMC snap-in administration in Microsoft Message Queuing 623
mobile computing operating system 2000 Professional as a, 26–27
model database 187, 212
MOLAP
model 776
selecting for data storage 798
money data type 208
monitoring
backup devices 1032
buffer cache 1033–34
cache 1002
capacity 48
CPUs 730
databases 186
disk drives 1003
distributor 729–30, 731
error log 38
I/O operations 102, 730
locking 999
locks 993
Log Reader Agent 735
memory usage 810
Merge Agent 758–59, 759
merge replication 767–68
MS DTC (Microsoft Distributed Transaction Coordinator) 632–33
network performance 244–45
networks 244–46, 736, 768
physical memory 809–10
processes 993
replication agents 642, 683–85, 757–59
response times 730
security 37–38
snapshot system 691–92
system memory 1002
system performance 39–40
| Top of Page |