F

fail-over, 250–252

clustering, 15, 269–279

and mirroring, 245

policies, 267–268

SQL Service Cluster, 269

Failover Partner attribute, 252

fail-safe operator, SQL Server Agent, 91

federations, 16, 262–263, 480–482

FETCH function, 505–507, 577

fetching, 55

fibers, 59

FIELDTERMINATOR argument, 433

file backups, 191–192

file fragmentation, 143

file initialization, instant, 139

file shares, 237–238, 284

file systems, 138–140, 271

FILE_ID function, 577

FILE_IDEX function, 577

FILE_NAME function, 577

FILEGROUP_ID function, 578

FILEGROUP_NAME function, 578

<filegroup> placeholder, 146–147

FILEGROUPPROPERTY function, 578

filegroups, 40–42, 140–142, 154, 189, 191–192

FILEGROWTH keyword, 149, 155–156

FILENAME keyword, 148, 154–155

FILEPROPERTY function, 578

files, database, 24–25

file/server data engines, 5

file-sharing services, 267

FILESPEC, 155

<filespec> items, 146–148

fill factor, 34

fillfactor argument, CREATE TABLE statements, 169

filtering published data, 218–219

FIRETRIGGERS argument, 435

FIRSTROW/LASTROW argument, 433–434

fixed server roles, 122

fixed-length (char) character data types, 303

flags, OpenXML, 521

flat-file databases, 5

float constants, 293

float data type, 302, 308, 578

FLOOR function, 318, 578

flow control programming, 451

flow-control, T-SQL, 324–328, 382

fn_get_sql function, 578

fn_helpcollations function, 578

fn_listextendedproperty function, 578

fn_my_permissions function, 578

fn_servershareddrives function, 578

fn_trace_geteventinfo function, 578

fn_trace_getfilterinfo function, 578

fn_trace_getinfo function, 578

fn_trace_gettable function, 578

fn_virtualfilestats function, 578

fn_virtualservernodes function, 578

FOR (XML) clause, 578

FOR ATTACH keyword, 147

FOR BROWSE option, 469

FOR clause, 382, 469–170

FOR XML argument, 81, 469–470, 515–518

forced fail-over, 245

FOREIGN KEY constraints, 35, 166, 169, 372–374

FOREIGN KEY ... REFERENCES constraints, 376

foreign keys, 31, 35, 307

FORMATFILE argument, 435

FORMATMESSAGE function, 579

forwarded ticket granting tickets (TGTs), 112

FQNSs (fully qualified namespaces), 342

FQTNs (fully qualified table names), 432, 460

fragmentation, file, 143

Framework Runtime, 332–336

FREETEXT function, 463, 579

FREETEXTTABLE function, 579

FROM clauses, 67, 432, 452, 459–461, 463

FROM function, 579

full database backups, 188–189

FULL OUTER join, 474

full recovery models, 185–186

full-differential backups, 194

full-text indexes, 38

full-text queries, 273

Full-Text Search, 16,18, 75, 77

FULLTEXTCATALOGPROPERTY function, 579

FULLTEXTSERVICEPROPERTY function, 579

fully qualified namespaces (FQNSs), 342

fully qualified table names (FQTNs), 432, 460

functions, T-SQL, 310–324

aggregate, 317–319

built-in, and SQL Server Profiler, 534

conversion, 321–324

date and time, 319

determinism of, 310–311

mathematical, 317

overview, 294, 310

text and image, 319–321