F

FAST_FORWARD cursors

cursor types, 121

selecting, 132

when to use, 133

federations of servers, 349–352

DDR (Data-Dependent Routing), 355–356

DPV (Distributed Partition View), 353–355

linked servers, 349–352

SODA (Service-Oriented Database Architecture), 357–358

targeting multiple servers, 349

fetch options, scrollable cursors, 129

FETCH statements, cursors and query performance and, 297

file DSN, 8

file groups

partition schemes for assigning to partitions, 346

partitioning and, 345

filters, SARG, 290

FOR XML clauses

exercise generating RAW XML data, 92

mode, 87

modes, 86

FORCE ORDER, query optimizer, 78

Forced Unit Access (FUA), 447

foreign keys

improving query performance, 206–208

in implementing declarative integrity, 196–199

join operations and, 49

used with subqueries, 205

FORWARD_ONLY cursors

cursor types, 121

selecting, 132

when to use, 133

fragment caching. See user control-level output caching

FREETEXT predicate, in full-text queries, 64

FROM clauses

APPLY operators used in, 55

FORCE ORDER option, 78

full-text query predicates and, 63

in SELECT statements, 455

PIVOT operators used with, 54

FUA (Forced Unit Access), 447

full-text indexes, 468

full-text queries, 63–64

function catalog views, 348

functions, 61–63

built-in functions in SQL Server 2005, 61

creating partition functions, 345

exercise creating partition function, 364

user-defined, 61