Microsoft® SQL Server® 2012 Bible

1348

Index

aggregate functions (cont inued)

nulls, 252

ORDER BY, 251

ranking functions, 265–266

result sets, 252–256

views, 283

aggregations

cubes, 1216–1217

SSAS, 1197

transactions, triggers, 896–900

Aggregation Design Wizard,

1216–1217

agile development, 25

Alerts, Object Explorer, 92

Algebrizer, 6, 1042

algorithms

SSAS data mining, 1289–1296

symmetric encryption, 857

aliases

columns, 128–129

ORDER BY, 134–135

SELECT, 279

views, 279

CSSASE, 183

PowerShell object

cmdlets, 775

tables, FROM, 118

UNION ALL, 235

views, 272

Alignment, 1244

ALL

nulls, 243

subqueries, 241–244

WHERE, 122–125

All Blocks Transactions, 1057

ALL SERVER, 901

ALL_ERRORMSGS, 589

AllowedBrowsingFolders, 1228

allowpagelocks, 1070

ALLOW_PAGE_LOCKS, 815

@allow_partition_switch, 957

ALLOW_ROW_LOCKS, 814, 815

ALTER, 276

data compression, 1105–1106

default language, 508

partitioned tables, 1124

schema binding, 462

SQL Audit, 970

SQL Profi ler, 922

stored procedures, 433–434

triggers, 881

alter

CDC, 954

Change Tracking, 948

ALTER ANY DATABASE, 624

ALTER DATABASE, 523, 554, 590,

1045

recursive triggers, 894

sp_dboption, 516

transaction log checkpoints,

564

ALTER DATABASE SET, 474

ALTER FUNCTION, 1124

ALTER INDEX, 553

alter index, 1069

ALTER INDEX REBUILD, 596, 598

bulk-loaded recovery model, 553

ALTER INDEX REORGANIZE, 595–

596, 598

ALTER PARTITION, 1124

ALTER PARTITION...NEXT USED,

1124

ALTER PARTITION...SPLIT

RANGE, 1124

ALTER QUEUE, poison message, 656

ALTER ROLE, 848

ALTER TABLE, 885

ALTER TABLE...SWITCH, 1125–1127

alternate key. See primary key

alter_view, 902

AlwaysOn Availability Groups

database mirroring, 685, 686

installation, 32

log shipping, 662

Object Explorer, 91

Service Broker, 655–656

SNAC, 76

AlwaysOn Replicas, CDC, 954

ambiguous column name error, 131

AMO. See Analysis Management

Objects

Analysis Management Objects

(AMO), 1289

Analysis Services. See SQL Server

Analysis Services

Analysis Services Scripting

Language (ASSL), 1171

Analytic Channel, Extended Events,

941

AND

columns_updated(), 888

full outer joins, 226

WHERE, 120, 127

and, 179–180

ANSI

confi guration, 514–521

connections, 475, 476

database, 474

defaults, 516–517

DELETE, 311

nulls, 1036

SSMS, 516

transaction isolation, 1071

T-SQL, 389

ANSI_NULL, 813

ANSI_NULL_DEFAULT, 516–517

ANSI_NULLS, 517

ANSI_PADDING, 518

Azure SQL Database, 813

ANSI_WARNINGS, 518–519

ANY

IN, 244

subqueries, 241–244

WHERE, 122–125

API

Windows Azure SQL Database , 75

XML, 341

AppendToFile, 794

application locks, 1087–1089

APPLY

derived tables, 245–246

multistatement table-valued

functions, 462

UDFs, 460–461

APP_NAME(), 191

Argo, 3

ARITHABORT, 519

ARITHIGNORE, 519

arrays, PowerShell, 772

ASSL. See Analysis Services

Scripting Language

association rules, SSAS data

mining, 1281, 1294–1295

associative tables, 157

subjective-matter experts, 158

asymmetric encryption, 853,

858–859

RSA, 859

asynchronous database mirroring,

691–692

asynchronous execution, SNAC, 77

asynchronous messaging

Service Broker, 647–659

SOAP, 648

XML, 648

ASYNC_NETWORK_IO, 935

atomic, consistent, isolated, and

durable (ACID), 291

concurrency, 26

recovery, 576

transactions, 1048–1049

transactional integrity, 19

attributes

dimensions, 1204–1205

domain integrity, 18

bindex July 23, 2012 2:44 PM V1

bindex.indd 1348bindex.indd 1348 7/31/2012 10:39:56 AM7/31/2012 10:39:56 AM

http://www.it-ebooks.info