Microsoft® SQL Server® 2012 Bible

1359

Index

Query Optimizer, 997, 1041–1042

query recompiles, 1044–1045

reading, 997–998

reuse, 1041–1046

SQL Profi ler, 996, 999–1000

SSMS, 996

views, 996–1000

XML, 996

exist(), 355

exotic joins, 230–231

expired passwords, 79

EXPIREDATE, 561

EXPLICIT, 361–363

Export Column, SSIS Data Flow,

1181

Express Edition, 36

Express LocalDB Edition, 36

expressions, 177–197. See

also common

table expressions;

multidimensional

expressions

aggregate functions, 251

bitwise operators, 179–181

CSSASE, 181–184

logical functions, 184–185

nulls, 185–190

operators, 178–179

ORDER BY, 133–134

SSIS, 1161, 1174

SSRS, 1250

Expression Builder, SSIS, 1161

Expression Language, SSIS, 1161,

1186–1187

Expression Task, SSIS Control Flow,

1173

Extended Events, 937–944

Actions, 939

Channels, 941

comparison operators, 940

deadlocks, 1065

Events, 939

installation, 68

Maps, 940

Object Explorer, 92, 942

object model, 937–941

Packages, 938

Predicates, 940

Service Broker, 657

Sessions, 940–941, 943

SNAC, 77

SQL Audit, 967

SQL Profi ler, 942

SSAS, 1232

System Monitor, 913

system_health, 941

Targets, 939–940

wait states, 936

EXTENDED_LOGICAL_CHECKS, 589

extensibility

C Data Type Extensibility, 71, 77

database, 18

normalization, 148

Extensible Key Management (EKM),

507

extents, 553

Extent Lock, 1066

external data

distributed queries, 367–377

linking, 367–369, 374–377

OLE DB, 374

pass-through distributed

queries, 380

Extract-Transform-Load (ETL), 7, 22

BI, 22

CDC, 954

client application, 17

data warehouses, 816

database extensibility, 18

SSIS, 816, 1147–1149,

1155–1194

F

-f, 481

facets, 533–535

fact dimensions, 1213

fact tables, 1150–1151

Fail Operation, 968

fail_operation, 968

failover. See also Windows Server

Failover Clustering

automatic, 690

partner, SNAC, 75–76

Failover_Partner, 76

FailureConditionLevel, 747–748

fatal errors, T-SQL, 424

/FEATURES, 59

federated databases, 1110

Federations, 385–386

FETCH, 261–262

ORDER BY, 261

row-level security, 862

T-SQL, 410–412

fetch, 874

fetch all query path, 1016–1017

@@Fetch_Status, 405

fi elds, SSRS datasets, 1236, 1253

Field Terminator, 427

fi fth normal form (5NF), 170

fi le differential recovery model, 549

File System Task, SSIS Control Flow,

1173

fi legroups

partitions, 1118–1120

primary

metadata, 788

Azure SQL Database, 814

@filegroup_name, 957

FILESTREAM, 78–79, 506–507, 760

data compression, 1099

database

mirroring, 687

snapshots, 636

Fill, 1244

fi ll factors, 598

fi lters

execution plans, 1002

GROUP BY, 255–256

HierarchyID, 328

indexes, 1035–1036

Object Explorer, 93

SQL Profi ler, 919

events, 923–924

SSRS datasets, 1237

fi lter by nonkey column query path,

1020–1021

fi lter by ordered composite index

query path, 1029

fi lter by unordered composite

index, 1030

fi lter by unordered composite index

query path, 1030

fi nd unmatched rows queries. See

set difference queries

fi rewalls, 34

fi rst normal form (1NF), 165–166

fi rst-generation data normalization,

21

FirstRow, 427

5NF. See fi fth normal form

fi xed memory, 486

Flat File, SSIS

Connection Managers,

1162–1163

Data Flow, 1177, 1179

FlightRecorder, 1228

Float, 175

fl oating windows, 83–84

floor(), 178

FLWOR. See FOR LET WHERE ORDER

BY RETURN

fn_get_audit_file, 974

fn_trace_geteventinfo, 928

Font, 1244

bindex July 23, 2012 2:44 PM V1

bindex.indd 1359bindex.indd 1359 7/31/2012 10:39:57 AM7/31/2012 10:39:57 AM

http://www.it-ebooks.info