Microsoft® SQL Server® 2012 Bible

1364

Index

logical fl ow

query statement, 114–116

SELECT, 116

logical functions, 184–185

logical tables, 888–889

logical transactions, 1050–1051

@logicallogin, 373

LOGIN, 508

logins

Object Explorer Security, 91

SSMS, 372–373

Transfer Logins, 1173

LoginMode, 844–845

log_reuse_wait_desc, 567

Lookup, SSIS Data Flow, 1181

lookup entities, 150

loops. See also specific loops

nested, 1001

lost updates, 1088–1089

LOWER(), 199

LSNs. See log sequence numbers

-lt, 773

LTRIM(), 199

M

-m, 481

Machanic, Adam, 495

maintainability, 431

maintenance jobs, 17, 28

Maintenance Plan, 604–612

database shrinking, 609

Design Surface, 604–605

Object Explorer, 92

Properties window, 607–608

Maintenance Plan Wizard, 604–605

Management Data Warehouse

(MDW), 977–992

confi guration, 978–982

data collection, 983–985

customization, 989–991

Disk Usage Summary, 986

Query Statistics, 986, 988

reports, 985–988

Server Activity History, 986–987

wait states, 936

Management Objects. See SQL

Management Objects

Management Studio. See SQL Server

Management Studio

Management Tools, SSMS, 1262

many-to-many relationship, 153,

156–158

dimensions, 1213

recursive pattern, 162

SQL DDL layer, 157

MAP. See Microsoft Assessment and

Planning

Map, 1243

Maps, Extended Events, 940

market basket analysis, 1281

MARS. See multiple active result

sets

master data management (MDM), 22

Master Data Services (MDS), 42

master data store, 22

master database recovery, 579–581

master key, 854

master.dbo.sp_add_log_

shipping_primary_

database, 675

master.dbo.sp_add_log_

shipping_primary_

secondary, 675

master.dbo.sp_add_log_

shipping_secondary_

primary, 675

Material Resource Planning (MRP),

647

mathematical operator, 178

Matrix, 1242

matrix reports, 1245–1247, 1251

max(), 250

max degree of parallelism,

493–495

hyperthreading, 494

OLTP, 495

Max Errors, 427

max text repl size, 509

max worker threads, 491–492

@@MAX_CONNECTIONS, 501

MAX_CPU_PERCENT, 1133

MAXDOP, 495

max_files, 969–970

maximum concurrent user

connections, 501

maximum server memory,

65–66

max_size, 599

MDM. See master data management

MDS. See Master Data Services

MDW. See Management Data

Warehouse

MDX. See multidimensional

expressions

media retention, 527–528

MEDIADESCRIPTION, 561

MEDIANAME, 561

MediaPassword, 561

MembersWithData, 1209

memory

AWE, 487

confi guration, 483–488

data compression, 1099, 1102

dynamic, 484–485

fi xed, 486

index create, 487–488

installation, 33, 65–66

maximum, 485

minimum, 485

minimum query, 486

Plan Cache, 1044

query wait, 486–487

Resource Governor, 1133, 1140

SSAS, 1228

MERGE, 291, 313–318, 392

LEFT OUTER JOIN, 315

OUTPUT, 320

partitioned tables, 1124

returning data, 320

SELECT, 292

transactions, 1049–1050

merge, CDC, 954

Merge, SSIS Data Flow, 1181

merge agent, 731–732

merge join, 1001

SSIS Data Flow, 1181

merge publ icat ion, 741–743

MERGE RANGE, 1124

merge replication, 731

message queue. See also Microsoft

Message Queuing

Service Broker, 649–651

SSIS Control Flow, 1173

message_enqueue_time, 656

metadata

data compression, 1100

data integrity, 19

data source view, 1203

database security, 20

DMOs, 409

primary fi legroup, 788

SSIS, 1177

T-SQL, 409–410

views, 288

Metadata Discovery, 71, 75

meta-patterns, 17

Microsoft Assessment and Planning

(MAP), 44

Microsoft Message Queuing (MSMQ),

648

SSIS Connection Managers, 1169

middle tiers, 18

min(), 250

min memory per query, 486

bindex July 23, 2012 2:44 PM V1

bindex.indd 1364bindex.indd 1364 7/31/2012 10:39:57 AM7/31/2012 10:39:57 AM

http://www.it-ebooks.info