failed packages, restarting, 380–382
failover clusters, 169–172, 170–171
FailPackageOnFailure property, 381
failures
diagnosing, 164
recovery. See recovery
Falling short of processing the specified number of rows in a given amount warning, 500
FAST option, 313
FAST table hint, 91
FASTFIRSTROW table hint, 91
fault tolerance, 164–165
database mirroring, 172
disk drives, 165–169, 166–169
high-availability solutions, 169–172, 170–171
log shipping, 172–173, 173
replication, 174–177, 174, 177
feature usage, SQLH2 for, 323
file and file groups
backups, 187–188
checking, 305–306
restores, 199–200
FILE resource, locks for, 127
File System task, 374
FILLFACTOR option
DBCC SHOWCONTIG, 312
for indexes, 97
Filter Table Rows page, 483–484
filtering in query plans, 87
fire suppression systems, 525
firewalls, 531
Flat Buffer Memory counter, 386
Flat Buffers in Use counter, 386
Flat File destination, 378
float data type, 441
fn_trace_ system stored procedures, 239
fn_trace_geteventinfo stored procedure, 18
fn_trace_getfilterinfo stored procedure, 18
fn_trace_getinfo stored procedure, 18
fn_virtualfilestats function, 32
folders, snapshot, 482, 491
For loop containers, 373
FORCE ORDER query hint, 91
ForcedExecutionResult property, 381
foreign key constraints
checking, 300
for integrity, 435–436, 436–437
replication, 493
fragmentation, 102–103, 102–103, 108–111
defragmenting, 310–312
degree, 312–314
detecting, 103–105
Fragmentation page, 109–110, 109
Free Megabytes counter, 231
free of error criteria for data, 402
Free Pages counter, 238
% Free Space counter, 230
Free System Page Table Entries (PTE) counter, 236
freeing procedure cache, 310
FREEPROCCACHE command, 51, 310
FREESYSTEMCACHE command, 51
FTP task, 374
full database backups, 183
full database restores, 196–197
full outer joins, 412–415, 412, 414–415
FULL recovery model, 180–181
Full Scans/sec counter, 233
full-text indexes, 34
Full-Text Search subsystem, 560
FULLSCAN option, 113
fully compatible jobs, 321
fuzzy grouping, 376, 426
fuzzy lookups, 377, 426