Microsoft® SQL Server® 2012 Bible

1375

Index

RESTORE DATABASE, 643–644

rolling back, 643–645

using, 638–645

Windows Explorer, 640

isolation, 79, 1082–1085

replication, 730

Snapshot Agent Security, 738

snapshot/transactional publication

creating, 735–738

pull subscription, 740

push subscription, 738–740

SSMS, 738

Snowfl ake Schema, data

warehouses, 1146–1147

SOA. See Service-Oriented

Architecture

SOAP. See Simple Object Access

Protocol

software requirements, installation,

32–33

Solution Explorer

dimensions, 1205

Report Designer, 1241

SSAS, 1195

SSMS, 83, 105

SOME

IN, 244

subqueries, 241–244

WHERE, 122–125

sort

execution plans, 1002

Query Designer, 132

reports, 1251–1252

SSIS Data Flow, 1182

sort, 771

Sort-Object, 775

sort-object, 771

SOS_SCHEDULER_YIELD, 935

SOUNDEX(), 204–206

Soundex functions, 203–207

@source_name, 956

@source_schema, 956

sp_, 433, 437

SP2. See Service Pack 2

sp_addlinkedserver, 371, 502

sp_addlinkedsrvlogin, 373

sp_addrole, 848

sp_addserver, 502

Sparklines, 1253–1255

mini-charts, 1254

Report Designer Toolbox, 1243

sp_attach_db, 615, 627

sp_configure, 472, 478, 480

sp_cycle_errorlog, 568

sp_dboption, 474, 523

ALTER DATABSSASE, 516

sp_describe_undeclared_

parameters, 410

sp_detach_db, 626–627

sp_dropserver, 372

sp_estimate_data_compression_

savings, 1104

sp_executesql, 440

sp_GetAppLock, 1087

sp_help, 404

sp_help tablename, 1070

sp_helptext, 434–435

Sphinx, 3

SPID, 602

@@SPID, 405

sp_indexoption, 1070

sp_Lock, 1087

SPN. See Service Principal Name

spool, execution plans, 1002

sp_procoption, 482–483

spreadsheets, 145

sp_recompile, 1045

sp_ReleaseAppLock, 1087

sp_server_diagnostics, 747

sp_settriggerorder, 896

sp_sml_prepareddocument, 441

sp_spaceused, 599

sp_trace_create, 927

option = 4, 929

sp_trace_generateevent, SQL

Profi ler, 922

sp_tracesetevent, 927

sp_trace_setstatus, 928

sp_updatestats, 597

.sql

batches, 391

Query Editor, 100

SQL Agent, SQL Profi ler, 924

SQL Audit, 967–975

actions, 971

ALTER, 970

audit trail, 974

Database Audit Specifi cations,

973

enabling/disabling, 971

Extended Events, 967

Object Explorer, 968, 974

queues, 968

Server Audit Specifi cation,

971–973

targets, 969–970

technology overview, 967–968

T-SQL, 970

where, 970

SQL authentication, 496, 836–837

Azure SQL Database, 802

Windows authentication,

837–838

Azure SQL Database

bcp, 826–829

BOL, 814–815

CREATE, 812

data, 801–830

migration, 807–829

Database Manager, 803–804

databases, 804–805

editions, 805

Generate and Publish Scripts

Wizard, 808–816

high-availability, 806

load balancing, 807

Object Explorer, 802

primary fi legroup, 814

scalability, 806–807

SQL authentication, 802

SSIS, 816–826

SSMS, 802–803

throttling, 806–807

use database, 812

SQL Batch Complete, 925

SQL Batch Start, 925

SQL DDL layer, 164

many-to-many relationship, 157

relational database design, 146

SQL Management Objects (SMOs)

authentication, 845

Copy Database Wizard, 617

libraries, 786

.NET Framework, 785

Object Explorer, 855

PowerShell, 845

scripts, 785–792

profi le fi les, 786

scripting, 793, 794

SSIS

Connection Managers, 1169

container, 1170

SSMS, 81

T-SQL, 786

URN, 784–785

SQL Profi ler

columns

organizing, 924

selecting, 921–923

counters, 919

Database Engine Tuning

Advisor, 925

deadlocks, 1063

events

fi lters, 923–924

bindex July 23, 2012 2:44 PM V1

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

http://www.it-ebooks.info