M


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




Microsoft SQL Server 2005. The Complete Reference
Microsoft SQL Server 2005: The Complete Reference: Full Coverage of all New and Improved Features
ISBN: 0072261528
EAN: 2147483647
Year: 2006
Pages: 239

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