Microsoft® SQL Server® 2012 Bible

1365

Index

mini-charts, 1254

minimum query memory, 486

minimum server memory, 65–66

Mining Models, Data Mining

Designer, 1285–1286

mirror server, 689

mirroring, database, 685–695

ADO.NET, 687

AlwaysOn Availability Groups,

685, 686

asynchronous, 691–692

availability, 686

confi guration, 693–694

data replication, 729

disaster recovery, 686

distributed transactions, 687

encryption, 686

FILESTREAM, 687

high-performance mode,

691–692

high-safety mode, 689

instances, 688

log shipping, 685

reports, 687

SLA, 688

SSMS, 694–695

synchronous, 689

TCP/IP, 693

transactions, 687

transaction logs, 688

WSFC, 687

model database installation, 68

ModifiedDate, 894

modify(), 355

modulo operator, 178

MOLAP. See Multidimensional OLAP

MomentDeleted, 313

Money, 175

monitor server, log shipping,

665–666

MOVE TO, 1128

MRP. See Material Resource

Planning

msdb system database recovery,

581–582

msdb.dbo.sp_add_log_shipping_

secondary_database,

676

msdb.dbo.sp_add_schedule, 675

msdb.dbo.sp_attach_schedule,

675, 676

msdb.dbo.sp_update_job, 676

msdo.dbo.sp_add_schedule, 675

msdo.dbo.sp_attach_schedule,

675

msdo.dbo.sp_update_job, 675

msg_audit_forced_shutdown, 968

MSMQ. See Microsoft Message

Queuing

multicast

Service Broker, 655

SSIS Data Flow, 1181

Multidimensional and Data Mining

mode, SSAS, 1223–1227

multidimensional expressions

(MDX), 1196, 1213

SSAS, 8

Multidimensional OLAP (MOLAP),

1197

multiple active result sets (MARS),

77–78

multiple assignment variables,

397–399

multiple conditions

joins, 231

WHERE, 127–128

multiple data sources, inner joins,

220–221

multiple outer joins, 227

multistatement table-valued

functions, UDFs, 462–464

multithreads

processor, 491–492

server confi guration, 471

multi_user, 524

MyServer, 786

N

-n, 482

Naïve Bayes algorithm, 1294

named instances, 58

Named Pipes, 72, 73

National Institute of Standards and

Technology (NIST), 857

Native Client. See SQL Server Native

Client

native mode, SSRS, 1261–1262

reports, 1266–1269

roles, 1271–1275

Nchar(), 174

-ne, 773

Nelson, Aaron, 913

nested CTEs, 240

nested IF, 400–401

nested loop, 1001

nested queries, 255–256

nested stored procedures, 451

nested subqueries, 241

nested transactions, 1052–1053

nested triggers, 522, 892–893

nested TRY...CATCH, 423–424

nested views, 281

@@NestLevel, 405

.NET Framework

Import and Export Wizard, 628

installation, 33

PowerShell, 769

SMOs, 785

Network Load Balancing (NLB),

1230

network packet size, 504

neural networks, 1293

New Data Source Wizard, 1227

New Linked Server, 369

New Page Restore, 82

New Trace, 920

New View, 274

newid(), 455

new_reseed_value, 593

newsequentialid(), 813, 815

GUID, 319

NIST. See National Institute

of Standards and

Technology

NLB. See Network Load Balancing

no relationship dimensions, 1213

NO_CHECKSUM, 561

NO_COMPRESSION, 561

nodes

HierarchyID, 330–331

SSMS, 82

Nodelist, SSIS container, 1170

nodes(), 354–355

NOFORMAT, 562

NOINDEX, 589

NO_INFOMSGS, 589

NOINIT, 562

NoLock, 1086

nonclustered indexes, 1009–1010

data compression, 1098

NonLeafDataHidden, 1209

NonLeafDataVisible, 1209

non-SARG-able expressions query

path, 1031–1032

NonStandardItemDescription,

154

NORECOVERY, 576, 682

log shipping, 666

RESTORE, 565

NOREWIND:REWIND, 562

normal forms, 164–170

normalization

costs, 147

data integrity, 19, 147

bindex July 23, 2012 2:44 PM V1

bindex.indd 1365bindex.indd 1365 7/31/2012 10:39:58 AM7/31/2012 10:39:58 AM

http://www.it-ebooks.info