Microsoft® SQL Server® 2012 Bible

1370

Index

Query Editor

bookmarks, 102

connecting query to server, 99

connection bar, 100

data modifi cation, 292

deadlocks, 1061

execution plans, 104–105, 996

options, 102

results, 103–104

server groups, 88

shortcuts, 102

.sql, 100

SQL Profi ler, 920

SSMS, 9, 83, 99–105

transactions, 1055

T-SQL, 101

batches, 102–103

Query Engine, 6

query execution plans. See

execution plans

query fl ow, 111–142

FROM, 117–120

result sets, 131–137

SELECT, 137–141

query governor cost limit,

501–502

Query Optimizer, 6, 105, 133

correlated subqueries, 244

execution plans, 997, 1041–1042

indexed views, 1037

UPDATE, 302–303

query path

bookmark lookup, 1022–1024,

1033

clustered index seek, 1017–1018,

1019

covering index, 1024–1027

fetch all, 1016–1017

fi lter by nonkey column, 1020–

1021

fi lter by ordered composite

index, 1029

fi lter by 2 X NC indexes, 1027–

1029

fi lter by unordered composite

index, 1030

indexes, 1014–1032

non-SARG-able expressions,

1031–1032

range seek, 1018–1020

Query Statistics, MDW, 986, 988

query wait, 486–487

queues. See also message queue;

Microsoft Message

Queuing

Service Broker, 651–652

SQL Audit, 968

Quick Watch, 82

/QUIET, 580

QUOTED_IDENTIFIER, 521

R

RAISERROR

CATCH blocks, 420–423

error-severity, 415

WITH LOG, 417

stored procedures, 450

sys.messages, 415–416

TRY...CATCH, 450

T-SQL error handling, 414–418

variable parameters, 415

rand(), 455

Randal, Paul, 510–511, 912

random rows, 141

range seek query path, 1018–1020

RANK(), 262–263

ranking functions

aggregate functions, 265–266

data, 259–269

RAW, 359–361

Raw File, SSIS Data Flow, 1177, 1179

RC encryption algorithm, 857

RDL. See Report Defi nition

Language

read committed, 1054

ReadCommitted, 1073–1074

locking hints, 1086

READONLY, 443

READ_ONLY, 524

ReadOnlyVariables, 1173

ReadPast, 1086

ReadUncommitted, 1086

READ_WRITE, 524

ReadWriteVariables, 1173

Real, 175

receive, 652

recordset, 1179

recovery. See also disaster

recovery

bulk operations, 548–549

complete, 582

confi guration, 525–529

durability, 548, 550

individual pages, 573–574

master database, 579–581

models, 525–526, 548, 549,

550–551

log shipping, 666

modifying, 555

sequence, 569

setting, 554–555

transaction logs, 567

msdb system database, 581–582

pain level, 548

password, 575

planning, 547–583

transactional integrity and,

547

problem detection, 568

sequences, 569

system databases, 579–582

transaction logs, 548, 549,

563–567, 1093

T-SQL, 574–579

RECOVERY, 576

recovery interval, 528–529, 564

recovery time objective (RTO),

662–663

Rectangle, 1242

recursive pattern

foreign keys, 161

many-to-many relationship, 162

PK, 161

relational database design

patterns, 161–162

self-joins, 227

recursive triggers, 522, 893–895

ALTER DATABASE, 894

ModifiedDate, 894

red-fl ag wait states, 935

REDO, 528, 1093

redundancy

availability, 662

database availability, 20

log shipping, 664

reference data stores, 22

referenced dimensions, 1213

referential database design

patterns, 163

referential integrity (RI)

AFTER, 881

database, 18–19, 151

DELETE, 311–312

DRI, 312

entity-value pairs pattern, 163

foreign keys, 151

full outer joins, 225

refl exive relationships, 227

Registered Servers

Properties page, 86–87

server groups, 88–89

SSMS, 82, 86–89

Registry, 782

regular dimensions, 1213

bindex July 23, 2012 2:44 PM V1

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

http://www.it-ebooks.info