Microsoft® SQL Server® 2012 Bible

1379

Index

nested, 241

in relational algebra, 214

scalar, 240–241

simple, 237–241

SOME, 241–244

tables, 242

Q (theta) joins, 231

Subreport, 1243

subscribers, 730

subscriptions

data-driven, 1276–1277

pull, 740

push, 740

SSRS, 1275–1277

subselects, 117

SUBSTRING(), 197–198, 1187

subtrees, 329–330

SUM(), 252

sum(), 250

supertype/subtype pattern,

159–160

@supports_net_changes, 956

Surface Area Confi guration Wizard,

477

surrogate keys, 1145–1146

SUSER_SNAME(), 191

suser_sname(), 872

suspended status, waiting state,

932

Switch, 774

Sybase, 3

symmetric encryption, 853,

856–858

algorithms, 857

decryption, 858

SSRS, backup, 1278–1279

synchronous database mirroring,

689

synonyms

Object Explorer, 91

views, 288–289

syntax

CTEs, 240

query statement, 112–113

sysadmin, 886

sysadmins, 569

sys.change_tracking_tables,

949

sys.configuration, 480

sys.conversation_endpoints,

657

sys.conversation_groups, 657

sys.conversation_priorities,

657

sys.database_files, 598

sys.databases, 474

log_reuse_wait_desc, 567

SysDateTime(), 192

SYSDATETIMEOFFSET(), 192

sys.dm_broker_activated_

tasks, 658

sys.dm_broker_connections, 658

sys.dm_broker_forwarded_

messages, 658

sys.dm_broker_queue_monitors,

658

sys.dm_db_index_operational_

stats, 1107

sys.dm_db_index_physical_

stats, 595

[sys].[dm_db_persisted_sku_

features], 37

sys.dm_exec_cached_plans, 1000

sys.dm_exec_connections, 476,

504

sys.dm_exec_describe_first_

result_set, 409–410

sys.dm_exec_describe_first_

result_set_for_

object, 410

sys.dm_exec_query_plan(plan_

handle), 1000

sys.dm_exec_query_stats, 1000,

1043–1044

sys.dm_exec_requests, 932, 1000,

1059

sys.dm_exec_sql_text(plan_

handle), 1000

sys.dm_os_waiting_tasks, 934

sys.dm_os_wait_stats, 932–934

sys.dm_tran_locks, 1055–1056,

1060

sys.fn_cdc_map_time_to_lsn,

958

sys.fulltext_languages, 508

sys.internal_tables, 949

sys.master_files, 599

sys.messages, 415–416

Sysname, 174

sys.remote_service_bindings,

657

sys.routes, 657

sys.server_triggers, 904

sys.service_contract_message_

usages, 657

sys.service_contracts, 657

sys.service_contract_usages,

658

sys.service_message_types, 658

sys.service_queue_usages, 658

sys.services, 658

sys.sql_modules, 287–288, 435

sys.syscomments, 287

System Confi guration

Checker, 47

system databases

database transfer, 627

recovery, 579–582

system functions

server environment

information, 210–211

T-SQL, 404–405

System Monitor

Database Engine, 911

Extended Events, 913

PerfMon, 910–913

SQL Profi ler, 913, 921

System Variables, 1185

system_health, 1065

Extended Events, 941

system-level roles, 1272

sys.transmission_queue, 658

sys.triggers, 885

DDL triggers, 904

SysUTCDateTime(), 192

T

tabbed windows, 84

tables. See also common table

expressions

aliases, FROM, 118

associative, 157

subjective-matter experts,

158

CDC, 956–957

Change Tracking, 948–949

data compression, 1098–1099

derived, 242

APPLY, 245–246

driving, 223

fact, 1150–1151

global temporary, 407

INSERT, 300–302

INSTEAD OF, 883

internal, 949–950

layers, 164

local temporary, 406

logical, 888–889

Object Explorer, 91

partitions, 27, 1117–1128

creating, 1122–1123

indexes, 1128

performance, 1117

queries, 1123

bindex July 23, 2012 2:44 PM V1

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

http://www.it-ebooks.info