Index F

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

Fast Bulk Copy process  
FAST FORWARD   2nd  
fat clients  
features (of SQL Server 2000)   2nd   3rd  
       new features   2nd   3rd   4th   5th  
federated database servers  
federation of servers  
federations  
FETCH  
FETCH NEXT  
fields
       defined  
file
       filegroups
               placement in physical design of databases   2nd   3rd   4th   5th   6th   7th  
file format
       speed of BCP  
FILE ID  
FILE NAME  
FILEGROUP ID  
FILEGROUP NAME  
FILEGROUPPROPERTY  
filegroups  
       backup and restore considerations   2nd  
       creating  
       placement in physical design of databases  
               RAID considerations   2nd   3rd  
               sequential versus random access   2nd   3rd  
       placement of objects   2nd   3rd   4th  
FILEPROPERTY  
files
       databases  
               creating  
               extensions  
               log  
               primary  
       filegroups  
               backup and restore considerations   2nd  
               creating  
               placement of objects   2nd   3rd   4th  
       formats  
       growth strategies   2nd  
       placement in physical design of database  
               RAID considerations   2nd   3rd  
               sequential versus random access   2nd   3rd  
       shrinking   2nd  
fill factor  
Fillfactor  
FILLFACTOR
       indexing   2nd   3rd  
filtering
       data   2nd   3rd  
               BETWEEN  
               IN  
               LIKE   2nd   3rd   4th  
               operators.   [See operators]
               returning TOP   2nd   3rd  
               selecting rows based on null values   2nd  
                user -defined functions   2nd   3rd   4th  
               with stored procedures   2nd   3rd  
       transactional replication  
filtering data
       CASE expressions   2nd   3rd   4th   5th  
       data model   2nd   3rd  
       derived tables   2nd  
       IN clauses   2nd  
       joins
               cross joins   2nd   3rd   4th  
               inner joins   2nd   3rd   4th   5th   6th   7th  
               outer joins   2nd   3rd   4th   5th   6th   7th  
               types of   2nd   3rd  
       order of operations  
       UNION operator   2nd   3rd   4th   5th  
       with GROUP BY operator and HAVING keyword   2nd  
filters
       setting  
FIRST  
first normal form (1NF)   2nd  
fixed roles   2nd  
fixed-form exams
       MCP exams   2nd  
       tips for taking   2nd  
Flash Review mode (PrepLogic practice test)  
Flash Review mode (PrepLogic practice tests)
       starting a session  
fn helpcollations  
FN LISTEXTENDEDPROPERTY  
fn servershareddrives  
fn trace geteventinfo  
fn trace getfilterinfo  
fn trace getinfo  
fn virtualfiestats  
fn virtualfilestats  
FOR XML operator  
       AUTO option   2nd   3rd  
       BINARY BASE64 option  
       EXPLICIT option   2nd   3rd   4th  
       RAW option   2nd  
FOREIGN KEY   2nd   3rd  
Foreign Keys   2nd  
foreign keys  
Foreign Keys
       cascading actions   2nd  
       constraints   2nd   3rd  
       domain integrity  
formatting
       data   2nd  
               CAST   2nd   3rd   4th  
               CONVERT   2nd   3rd   4th  
FORWARD ONLY   2nd  
four part names  
FREETEXT
       executing full-text searches  
FREETEXT searches   2nd  
FREETEXTTABLE searches   2nd  
FROM
       data retrieval   2nd   3rd   4th  
FULL OUTER JOIN statement   2nd   3rd   4th  
Full recovery model  
full-text indexes   2nd  
       creating   2nd   3rd   4th  
Full-Text Indexing Wizard   2nd   3rd   4th  
full-text searches  
       executing   2nd  
       executing with FREETEXT  
       LIKE  
full-text stored procedures   2nd  
FULLTEXTCATALOGPROPERTY  
FULLTEXTSERVICEPROPERTY  
functions
       ABS()  
       aggregate functions   2nd   3rd  
               data management aggregate functions   2nd   3rd  
               statistical aggregate functions   2nd   3rd  
       built-in functions   2nd  
       CAST   2nd   3rd   4th  
       character functions   2nd   3rd  
               DATALENGTH   2nd  
               SUBSTRING   2nd  
       configuration functions   2nd   3rd  
       CONVERT   2nd   3rd   4th  
       CURSOR STATUS()   2nd   3rd  
       DATALENGTH()  
       date functions   2nd  
       DATEADD   2nd   3rd  
       DATEDIFF   2nd  
       DATENAME   2nd  
       DATEPART   2nd  
       EXIST()  
       GETDATE   2nd  
       getdate()  
       GETDATE()  
       hash functions  
       ISNULL()  
       mathematical functions   2nd   3rd  
       meta data functions   2nd   3rd   4th  
       NEWID()  
       OPENQUERY   2nd  
       OPENROWSET   2nd   3rd   4th   5th   6th  
               creating linked servers   2nd   3rd   4th   5th   6th   7th  
               linked server usage   2nd  
       OPENXML   2nd   3rd  
               preparing XML documents   2nd  
               usage   2nd   3rd   4th   5th   6th  
       scalar functions  
       substring  
       system functions   2nd   3rd   4th   5th   6th  
               information schema   2nd  
               system stored procedures   2nd  
       system statistical functions   2nd   3rd  
       user-defined   2nd   3rd   4th  
       user-defined functions   2nd  
       user-defined functions.   [See user-defined functions]
       versus stored procedures