Microsoft® SQL Server® 2012 Bible

1360

Index

footer, reports, 1251

For

PowerShell control fl ow

command, 774

SSIS container, 1170

FOR LET WHERE ORDER BY RETURN

(FLWOR), 363–365

FOR XML, 355–363

foreach

PowerShell, 772

SSIS container, 1170

ForEach-Object, 775

Forecasting, SSAS data mining,

1282

foreign keys

clustered indexes, 1033

Database Diagrams, 95–96

ON DELETE CASCADE, 312

domain integrity lookup

pattern, 160

entities, 151–152

object permissions, 845

physical schema, 24

recursive pattern, 161

relational database design,

151–152

RI, 18–19, 151, 311

Security table, 862

subassemblytype, 150

triggers, 881

FORMAT, 203

FORMAT:FORMAT, 562

format-list, 777

FormatString, 1212

fourth normal form (4NF), 169

FROM

data sources, 117–120

DELETE, 310–311, 890

inline table-valued functions,

458

INSERT, 890

joins, 217

ORDER BY, 117

outer queries, 245

query fl ow, 117–120

SELECT, 112–113, 117, 242

table aliases, 118

UDFs, 453

UPDATE, 304–305, 890

WHERE, 113, 117, 120

from, 96

FROM DUAL, 112

fSecurityCheck, 871–872

FTP

ports, 73

SSIS

Connection Managers, 1169

Control Flow, 1173

FULL, 554

full outer joins, 224–226

full recovery model, 526, 548, 550,

551–553

sequence, 569

full set difference queries, 233

full-text, FROM, 117

Full-Text Search, SQL Profi ler,

922

fully qualifi ed names, 119–120

functions. See specific types

Fuzzy Grouping, 1181

Fuzzy Lookup, 1181

G

-g, 482

Gauge, 1243

-ge, 773

GenColUpdated(), 888

General, 1243

General page, SSMS, 370

backup, 557

generalization

entities, 150

relational database design,

149–150

Generate and Publish Scripts

Wizard

Object Explorer, 808

Azure SQL Database, 808–816

SSMS, 808

T-SQL scripts, 808

GetAncester(), 331

Get-ChildItem, 771, 783

Get-Command -Module SQLPS, 784

Get-Content, 773

GETDATE(), 1187

GetDate(), 192

get-executionpolicy, 63

Get-Help, 776–777

GetLevel(), 333

Get-Member, 786

get-process, 771

GetUTCDate(), 192

GetValue, 797

Get-WMIObject, 777

$servers, 779

global temporary tables, 407

GO

batches, 390

SSMS, 433

GoDaddy, 859

GOTO, 402–403

GRANT, 845

grant, 844

granularity, transaction locks,

1066–1067

graphical view, query statement,

113–114

grep, 771

Grid pane, Query Designer,

97

GROUP BY, 241, 253–256

aggregate functions, 283

DISTINCT, 138

fi lter, 255–256

nested queries, 255–256

SQL Profi ler, 924

UNION, 254

group listeners, SNAC, 76

grouping, reports, 1251–1252

-gt, 773

GUI, SSMS, 81, 434, 802

GUID, 742

EncryptByKey, 858

newsequentialid(), 319

temporary keys, 857

gwmi, 777

H

-h, 482

hardware

data compression, 1099

installation, 32–33

server environment, 17

Smart Database Design, 29

hash match, 1001

HAVING, 256

scalar subqueries, 240–241

header, reports, 1251

heaps

data compression, 1098, 1103

indexes, 1012–1013

HERE, 122–125

hierarchies, 325–337

attributes, 1206–1207

CTEs, 335–336

encryption, 854–855

indexes, 334

PowerPivot, 1311–1315

user-defi ned database roles,

848–849

XML, 336–337

HierarchyID, 326–334

CLR, 326

bindex July 23, 2012 2:44 PM V1

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

http://www.it-ebooks.info