mailing engines, SQL Server, 91–93
maintenance
database engine, 93–94
standby server, 234
maintenance plan, backup, 206–209
Maintenance Plan Wizard, 207–208
maintenance statements, DBCC, 557
managed code, 336
Managed execution, Common Language Runtime, 332, 339–340
managed object files (MOFs), 538
management, .NET Framework, 9
Management Objects architecture, SQL (SQL-SMO), 18, 162–163, 370, 379, 385
Management Studio
autocommit transactions, 500
backing up, 194–198
configuring log shipping with, 237–242
creating databases with, 158–159
creating foreign key constraints in, 373–374
creating views in, 478–479
database engine administration, 83–86
database mirroring, 246
database roles, logins, and users, 129–132
Design Table console, 368–370
enabling CLR and installing stored procedures, 418–419
log shipping, 236
overview, 82–83
and stored procedures, 403, 406–407
subscribing to publications with, 221–226
and trigger creation, 385
manual fail-over, 245
manual log shipping configuration, 237
manual memory management, 341
MARS (multiple active result sets), 140
Master databases, 24
mathematical functions, T-SQL, 317
mathematical operations, 294
MAX aggregate function, 319
max async io configuration option, 58
MAX COMPUTE argument, 467
MAX function, 582
max server memory, 53, 277
max worker threads configuration option, 59
MAXERRORS argument, 434
MAXSIZE keyword, 149, 155
MB (megabyte) suffix, 148–149
MBSA (Microsoft Baseline Security Analyzer), 279
megabyte (MB) suffix, 148–149
memory chips, 53
memory management
automatic, 337
DBMS, 52–57
address space, 56–57
Address Windowing Extensions (AWE), 55–56
overview, 52–53
page files and virtual memory manager (VMM), 53–54
paging, 54–55
Memory Manager SQL Server object, 548
memory pool, 56, 70
memory usage, 553, 555
merge replication, 217–218
messages, Simple Object Access Protocol, 528–529
metadata, 308, 338–339, 346
Metadata feature, CLS, 335
MetaProperty, OpenXML SchemaDeclaration, 521
Methods feature, CLS, 335
Metrics for Monitored Components, 536
Microsoft Baseline Security Analyzer (MBSA), 279
Microsoft Certificate Services, 116–117
Microsoft cluster models, 263–270,
Microsoft, (MSCS)
designing SQL Server cluster, 264–268
Model A: high-availability solution and static load balancing, 263–264
Model B: “hot spare,” 268–269
Model C: partial cluster, 269
Model D: virtual server only with no fail-over, 269–270
Model E: hybrid solution, 270
overview, 263
Microsoft Common Object File Format (COFF), 343–344
Microsoft Distributed Transaction Coordinator (MSDTC), 16–18, 75, 77, 275, 280–281
Microsoft Full-Text Search, 77
Microsoft Intermediate Language (MSIL), 337–338, 345
Microsoft Knowledge Base, 273
Microsoft Message Queuing Services (MSMQ), 15
Microsoft .NET Framework. See .NET Framework
Microsoft Portable Executable (PE) format, 343–345
Microsoft Search service, 38
Microsoft Transaction Server (MTS), 15
Microsoft Windows Catalog and Hardware Compatibility List, 274
MIN aggregate function, 319
MIN COMPUTE argument, 467
MIN function, 582
min server memory, 53
mirrored disks, 178
mirroring, 244–249
creating mirror, 246–249
fail-over, 245
mirror session, 245–246
overview, 15, 244–245
resolving errors, 249–250
witness server, 245
miscellaneous statements, DBCC, 557
mixed extents, 40
Mixed Mode Authentication, 108
model databases, 143–144
modeling level data integrity, 358
modeling multinode clusters. See server clusters
models, Microsoft cluster, 263
MODIFY FILE argument, 154–155
MODIFY FILEGROUP argument, 154
MODIFY NAME argument, 154
Modulo (%) operator, 295, 559
MOFs (managed object files), 538
money constants, 293
money data type, 302, 582
money value numbers, 324
monitored network addresses, default, 80
monitoring tools, 531–557
for bottlenecks, 552–555
Database Console Commands statements, 556–557
familiarity with servers, 551–552
overhead, 556
overview, 531–533
performance, 538–540
platform tools, 540–551
Add Counters dialog box, 544–546
monitoring Processes, 542
monitoring with T-SQL statements, 548–549
overview, 540
Performance Console, 542–543
Performance Logs and Alerts, 549–551
SQL Server objects, 546–548
System Monitor, 543–544
Task Manager, 541–542
preparations, 537–538
SQL Server Profiler, 533–536
MONTH function, 320, 582
MOVE COVERSATION function, 582
MSCS (Microsoft Cluster Service), 261, 270–273, 278–280
MSDB database, 23
MSDTC (Microsoft Distributed Transaction Coordinator), 16–18, 75, 77, 275, 280–281
MSIL (Microsoft Intermediate Language), 337–338, 345
MSMQ (Microsoft Message Queuing Services), 15
MTS (Microsoft Transaction Server), 15
MULTI_USER option, 156
multinode clusters. See server clusters
multiple active result sets (MARS), 140
Multiply (*) operator, 559
Multiply (*) operators, 295
multiprocessors, 257–260, 263
multithreading, 59
multitier client/server systems, 15
MUST_CHANGE option, login creation scripts, 131