Microsoft® SQL Server® 2012 Bible

1363

Index

in relational algebra, 214,

215–231

SELECT, 215, 217

self, 227–229

Q(theta), 231

T-SQL, 217, 222

WHERE, 215

junction tables. See associative

tables

K

Katmai, 4

Kerberos

AD, 1271

Windows authentication

delegation, 838

Key Lock, 1066

Key Performance Indicator (KPI)

cubes, 1214

PowerPivot, 1308–1311

KeyDuplicate, 1222

KeyErrorAction, 1222

key_guid(), 858

KeyNotFound, 1222

key_phrase, 857, 858

KPI. See Key Performance

Indicator

L

-l, 481

labels, 402–403

@@LangID, 405

@@Language, 405

large value data types, 78

layers. See also specific layers

cause-and-effect relationship,

28

PK, 164

relational database design, 164

tables, 164

LazyProcessing, 1228

LCID. See locale identifi er

LCK_x, 935

-le, 773

least privilege, 20

LEFT(), 199

LEFT OUTER JOIN, 1149, 1151

MERGE, 315

left set difference query, 232–233

legacy

error handling, T-SQL, 412–414

Object Explorer, 92

software, 145

LEN(), 199, 1187

Liberty, 4

libraries

Power View connection fi le, 1330

SMOs, 786

licenses, 40–41

life-cycle planning, 17

lift charts, 1286–1287

lightweight pooling, 492–493

LIKE

COLLATE, 126

wildcards, 125–126

like, 923

-like, 773

Line, 1242

linear regression algorithm, 1291

Linked Servers, 372

Object Explorer Security, 91

SSMS, 368

linking

Access, 376–377

Excel, 374–376

external data, 367–369, 374–377

lists, clustered indexes, 1008

SSMS, 369–371

T-SQL, 368, 371–373

List, 1242

lists

linked clustered indexes, 1008

PowerShell modules, 782

reports, 1251

stored procedures, 439–442

subqueries, 241

triggers, 885–886

user-defi ned database roles,

849–850

WHERE, 122–125

load balancing, 747

NLB, 1230

Azure SQL Database, 807

LOAD:UNLOAD, 562

local distributed queries,

377–378

Local Publications, 91

Local Server Group, 88

Local Subscriptions, 91

local temporary tables, 406

LocalDB, 71, 75

locale identifi er (LCID), 508

local-partition views, 1111–1116

locks

application, 1087–1089

concurrency, 26

duration, 1069

exclusive, 1068

indexes, 1069–1070

intent, 1068–1069

optimistic, 1088

pessimistic, 1088

rows, 1048

schemas, 1069

shared, 1067

SQL Profi ler, 922

System Monitor, 912

timeouts, 1069

transactions, 1047

contention, 1068

default, 1054–1056

granularity, 1066–1067

isolation, 1066

mode, 1067–1069

monitoring, 1057–1060

queries, DMVs,

1059–1060

updates, 1068

lost, 1088–1089

Lock Manager, 6

LOCK PAGES IN MEMORY, 487

locking hints, 1085–1086

@@Lock_TimeOut, 405

log sequence numbers (LSNs)

boundary options, 958

CDC, 954, 958–959

log shipping, 661–684

AlwaysOn Availability Groups,

662

availability, 661–664

backup, 668

confi guration, 666–677

SSMS, 667–675

T-SQL, 675–676

data replication, 729

database

mirroring, 685

snapshots, 636

defi ning, 664–676

modifying, 678–682

monitor server, 665–666

monitoring, 677–678

Object Explorer, 667

primary server, 665, 683

recovery model, 666

redundancy, 664

removing, 678–682

role switching, 682–683

SSIS, 683

transaction logs, 668–669

warm standby, 663–664, 665,

683

Log Shipping Wizard, 664

LoggingMode, 1188

bindex July 23, 2012 2:44 PM V1

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

http://www.it-ebooks.info