Microsoft® SQL Server® 2012 Bible

1372

Index

Restore-SqlDatabase, 784

restrict, in relational algebra, 213

restricted_user, 524

result sets, 78

aggregate functions, 252–256

MARS, 77–78

ORDER BY, 131–137

query fl ow, 131–137

SELECT, 296–298

stored procedures, 298–300,

448–450

$Results, 792

Results pane, Query Designer, 97

ResultSet, 1172

RETAINDAYS, 561

RETURN

scalar functions, 455

stored procedures, 446–448, 450

triggers, 894

return on investment (ROI), 28

return values, XML, 351–352

REVERT, 845

REVOKE, 845

revoke, 844

REWIND, 562

RI. See referential integrity

RID lookup, 1002

RIGHT(), 199

Rivest, Ron, 857

RMOs. See Replication Management

Objects

@rmtpassword, 373

@rmtuser, 373

ROI. See return on investment

ROLAP. See relational OLAP

/ROLE, 59

roles. See also user-defi ned

database roles

item-level, 1273

public, 847

SSMS, 1271, 1273

SSRS native mode, 1271–1275

switching, log shipping,

682–683

system-level, 1272

@role_name, 956

ROLLBACK, 896

rollback transaction, 874, 1050

catch, 1051

rolling partitions, 1127–1128

Roosevelt, Franklin, 203

RootMemberIf, 1209

Rosetta, 4

rows

Change Tracking, 951–953

clustered indexes, 1033

constructors, 117

data compression, 1098, 1099–

1100, 1106

default, INSERT, 300

disappearing, 285

fi ltered indexes, 1035

inner joins, 218–220

INSERT/VALUES, 293–296

INSTEAD OF, 884

intersection unions, 235

locks, 1048

random, 141

relational database design,

145–146

SELECT, 395

versions, 1083–1085

WHERE, 285

Row Count, 1182

Row Lock, 1066

Row Sampling, 1182

Row Terminator, 427

@@RowCount, 313, 405

@@rowcount, 413–414

rowguid, 813

row-level security, 861–875

permissions, 863–868

checking, 870–875

triggers, 874–875

updates, 868–870

Windows authentication,

872–874

RowLock, 1086

ROW_NUMBER, 259–260

ROW_NUMBER(), 259–262

Rows per batch, 427

ROWS/RANGE, 266

Rowversion, 176

RSA, 859

RTO. See recovery time objective

RTRIM(), 199

Rules of One, 148

runaway triggers, 894

runnable status, waiting state, 932

running status, waiting state, 932

Russell, Robert C., 203

S

-s, 482

safety full, 690

/SAPWD, 59, 580

Sarbanes-Oxley Act, 22

SARG. See search argument

save points, 1054

scalability

advanced, 27

cluster ing, 746–747

concurrency, 1047

database, 19–20

Smart Database Design, 24

Azure SQL Database, 806–807

scalar functions, 190–197

date/time, 191–196

RETURN, 455

UDFs, 455–457

user information functions, 191

scalar subqueries, 240–241

scalar values

entities, 169

1NF, 165–166

SCAN, 1006

scan for startup procs,

482–483

scans, SQL Profi ler, 922

scatter charts, Power View, 1340–

1342

scatter plots, SSAS data mining,

1286–1287

schemas

batches, 390

binding, UDFs, 461–462

database, 17

locks, 1069

partitions, 1121

physical

indexes, 25

Smart Database Design, 24

scripts, 620

Snowfl ake Schema, data

warehouses, 1146–1147

Star Schema

data warehouses, 22, 1144–

1146

surrogate keys, 1145–1146

tables, 171

XML, 341, 346–350

Schema Defi nition Language (XSD),

341

Schema Generation Wizard, 1196

schema modifi cation lock (Sch-M),

1069

schema stability lock (Sch-S), 1069

Sch-M. See schema modifi cation

lock

Sch-S. See schema stability lock

scope

DDL triggers, 902–903

SSIS variables, 1186

variables, 393–394

bindex July 23, 2012 2:44 PM V1

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

http://www.it-ebooks.info