MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide

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