Microsoft® SQL Server® 2012 Bible

1378

Index

SQL Server Reporting Services

(SSRS) (cont inued)

layout, 1251–1255

Report Wizard, 1237–1239

reports, 1233–1259

deploying, 1265–1271

native mode, 1266–1269

SharePoint, 1269–1271

SSDT, 1265–1266

restore, 1269, 1279–1280

security, 1271–1277

SharePoint integrated mode,

1262–1265

SQL Profi ler, 924

SSAS cubes, 1271

subscriptions, 1275–1277

symmetric encryption, backup,

1278–1279

Word, 1269

SQL Statistics, 911

SQL Trace

SQL Profi ler, 919–929

using, 927–929

/SQLBACKUPDIR, 60

sqlcmd, 11

SqlConnection, 791

SQLGetData, 77

SQLMaint, 612

SQLOS. See SQL Server Operating

System

sqlos, 938

SQLPolicy, PowerShell, 783

sqlps.exe, 771

DLLs, 785

SQLRegistration, PowerShell, 782

sqlserver, 938

SQLSERVER PSDrive, 782–783

SQLSERVER:DAC, directories,

782–783

SQLSmoObject, 795

SQLSourceType, SSIS Control Flow,

1172

SQL_SS_TIME2, 76

SQLStatement, SSIS Control Flow,

1172

/SQLSVCACCOUNT, 60

/SQLSVCSTARTUPTYPE, 60

$sqlsvr, 786

/SQLSYSADMINACCOUNTS, 60, 580

/SQLTEMPDBDIR, 59

/SQLTEMPDBLOGDIR, 60

Sql_variant, 177

SSAS. See SQL Server Analysis

Services

ssbdiagnose, 657

SSDT. See SQL Server Data Tools

SSIS. See SQL Server Integration

Services

SSIS Designer, 1159, 1161

Control Flow tab, 1169–1175

precedence, 1174–1175

tasks, 1170–1174

Data Flow, components, 1175–

1183

parameters, 1183–1185

variables, 1185–1186

SSL

clustering confi guration, 750

ports, 73

SSMS. See SQL Server Management

Studio

SSRS. See SQL Server Reporting

Services

SS_TIMESTAMPOFFSET, 76

Standard Edition, 12, 36

table partitions, 1117

STANDBY, 576

log shipping, 666

Star Schema

data warehouses, 22, 1144–1146

surrogate keys, 1145–1146

StarFighter, 3

start/stop, confi guration, 480–483

startup

parameters, Confi guration

Manager, 480–482

stored procedures, 482–483

statements, 137

batches, 390

CTEs, 137

physical fl ow query statement,

116–117

queries, 390

STATISTICS PROFILE, 996, 999

STATS, 561

StDev, 251

STOPAT, 576

STOPATMARK, 576

STOPBEFOREMARK, 576

STOP_ON_ERROR, 561

storage

backup, database availability,

20

data, cubes, 1219

installation, 33

Object Explorer, 91

Storage Engine, 6

data compression, 1097, 1102

stored procedures, 431–451

ALTER, 433–434

consistency, 431

CREATE, 433

data

passing, 437–444

returning, 444–451

DDL, 432–434

default parameter values,

438–439

DROP, 434

encryption, 435–436

executing, 436–437

input parameters, 439–444

lists, 439–442

maintainability, 431

managing, 432–437

nested, 451

OUTPUT, 320

output parameters, 445–446,

450

parameter values, 438–439

partitions, 1116

performance, 431, 432

RAISERROR, 450

remote, 436–437

result sets, 298–300, 448–450

RETURN, 446–448, 450

security, 431

SELECT, 450

SQL Profi ler, 922

SSMS, 450

GUI, 434

startup, 482–483

tables, 442–444

triggers, 894

T-SQL, 432

views, 434–435

XML data types, 441–442

strings

concatenation operator, 178

functions, 197–207

values, 441

STUFF(), 198

$stuff, 772

subassemblytype, 150

subjective-matter experts

associative tables, 158

domain integrity layer, 164

subqueries, 237–246

FROM, 117

IN, 241

ALL, 241–244

ANY, 241–244

correlated, 244–246

difference unions, 236

lists, 241

bindex July 23, 2012 2:44 PM V1

bindex.indd 1378bindex.indd 1378 7/31/2012 10:39:59 AM7/31/2012 10:39:59 AM

http://www.it-ebooks.info