M

managed code

implementing procedural data integrity, 208

reliability and, 433

MARS (Multiple Active Result Sets), 170–183

compared with cursors, 170

enabled for use with SNAC ODBC provider, 171

enabled for use with SqlClient .NET provider, 172

enabling for use with SNAC OLEDB provider, 171

exercise comparing query execution, 175–183

overview of, 5, 170

transactions and, 173

MCP (Microsoft Certified Professional), xxvi

MDAC (Microsoft Data Access Components), xx

ADO (ActiveX Data Objects), 10–11

as data provider, 4

ODBC (Open Database Connectivity), 8–9

OLE DB (Object Linking and Embedding Database), 10

recommended use as data provider, 5

software requirements for Exam 70–442, xxi

MDX (Multidimensional Expression), 155

MeasureGroup class, AMO OLAP, 155

memory

application performance issues, 385

expanding limits for 32-bit CPUs, 407

memory use statistics, 441–443

optimizing data storage and, 332

memory nodes, SQLOS, 410

merge replication, 359

metrics

for analyzing query performance, 285

page reads, 285

query cost, 285

query execution time, 286, 294

Microsoft Certified Professional (MCP), xxvii

Microsoft Certified IT Professional (MCITP). See Exam 70–442

Microsoft Data Access Components. See MDAC (Microsoft Data Access Components)

Microsoft Developer Network. See MSDN (Microsoft Developer Network)

Microsoft Full-Test Engine for SQL Server (MSFTESQL), 63

Microsoft Press, technical support options, xxvii

Microsoft SQL Server Management Studio. See SQL Server Management Studio

Microsoft Visual Studio 2005. See Visual Studio 2005

Microsoft Web Application Stress Tool

installing, xxiii

software requirements for Exam 70–442, xx

Microsoft.SqlServer.ConnectionInfo assembly, 146

Microsoft.SqlServer.RegSvrEnum assembly, 146

Microsoft.SqlServer.Replication.dll assembly, 150

Microsoft.SqlServer.Rmo.dll assembly, 150

Microsoft.SqlServer.ServiceBrokerEnum assembly, 146

Microsoft.SqlServer.Smo assembly, 146

Microsoft.SqlServer.SmoEnum assembly, 146

Microsoft.SqlServer.SqlEnum assembly, 146

Microsoft.SqlServer.WmiEnum assembly, 146

MiningStructures, AMO, 154

mirroring, storage engine and, 446

mode, FOR XML clause, 86–88

modify method, XML DML statements, 84

monitoring memory use, 441

msdb database, 225

MSDN (Microsoft Developer Network)

query hints, 73

references for RMO, 153

MSFTESQL (Microsoft Full-Test Engine for SQL Server), 63

Multidimensional Expression (MDX), 155

Multiple Active Result Sets. See MARS (Multiple Active Result Sets)