لطفا منتظر باشید ...
F
fact
A row in a fact table in a data warehouse. A fact contains values that define a data event (such as a sales transaction).fact table
A central table in a data warehouse schema that contains numerical measures and keys relating facts to dimension tables. Fact tables contain data that describes specific events within a business, such as bank transactions or product sales. See also data warehouse, dimension table, star join, star schema.Federal Information Processing Standard (FIPS)
Standards that apply to computer systems purchased by the U.S. government. Each FIPS standard is defined by the National Institute of Standards and Technology (NIST). The current standard for SQL products is FIPS 127-2, which is based on the ANSI SQL-92 standard. ANSI SQL- 92 is aligned with ISO/IEC SQL-92.fetch
An operation that retrieves a row or block of rows from a cursor. Transact-SQL batches, stored procedures, and triggers use the FETCH statement to fetch from Transact-SQL cursors. Applications use application programming interface (API) fetch functions.field
An area in a window or record that stores a single data value. Some databases, such as Microsoft Access, use the word 'field' as a synonym for 'column.'
field length
In bulk copy, the maximum number of characters needed to represent a data item in a bulk copy character format data file.field terminator
In bulk copy, one or more characters marking the end of a field or row, separating one field or row in the data file from the next.file
In SQL Server databases, a basic unit of storage for a database. One database can be stored in several files. SQL Server uses three types of files: data files (which store data), log files (which store transaction logs), and backup files (which store backups of a database).file DSN
Stores connection information for a database in a file that is saved on your computer. The file is a text file with the extension .DSN. The connection information consists of parameters and corresponding values that ODBC Driver Manager uses to establish a connection.file storage type
Defines the storage format used in the data file that transfers data from a bulk copy OUT operation to a bulk copy IN operation. In native mode files, all data is stored using the same internal structures that SQL Server 2000 uses to store the data in a database. In character mode files, all data is converted to character strings.filegroup
In SQL Server, a named collection of one or more files that forms a single unit of allocation.fill factor
An attribute of an index that defines the amount of free space on each page of the index. FILLFACTOR accommodates the future expansion of table data and reduces the potential for page splits. FILLFACTOR is a value from 1 through 100 that specifies the percentage of the index page to be left empty.filter
A set of criteria that controls the set of records returned as a result set. Filters can also define the sequence in which rows are returned.filtering
The ability to restrict data based upon criteria defined in the WHERE clause of a SQL statement. For replication, filtering occurs on table articles defined in a publication. The result is partitions of data that can be published to Subscribers. See also partitioning, vertical filtering.FIPS
See Federal Information Processing Standard (FIPS).
firehose cursor
An obsolete term for the default result set. See also default result set.fixed database role
A predefined role that exists in each database. The scope of the role is limited to the database in which it is defined.fixed server role
A predefined role that exists at the server level. The scope of the role is limited to the SQL Server instance in which it is defined.FK
See foreign key (FK).flattened interface
An interface created to combine members of multiple interfaces.flattened rowset
A multidimensional data set presented as a two-dimensional rowset in which unique combinations of elements of multiple dimensions are combined on an axis.float data type
A data type that holds floating- point number data from -1.79E + 308 through 1.79E + 308. Float, double precision, and float(n) are SQL Server float data types.foreign key (FK)
The column or combination of columns whose values match the primary key (PK) or unique key in the same or another table. The FK is also called the referencing key.foreign table
A table that contains a foreign key.forward-only cursor
A cursor that cannot be scrolled; rows can be read only in sequence from the first row to the last row.fragmentation
Occurs when data modifications are made. You can reduce fragmentation and improve read-ahead performance by dropping and recreating a clustered index.full outer join
A type of outer join in which all rows in all joined tables are included (whether they are matched or not).full-text catalog
Stores all of the full-text indexes for tables within a database.full-text enabling
The process of allowing full-text querying to occur on the current database.full-text index
The portion of a full-text catalog that stores all of the full-text words and their locations for a given table.full-text query
As a SELECT statement, a query that searches for words, phrases, or multiple forms of a word or phrase in the character-based columns (of char, varchar, text, ntext, nchar, or nvarchar data types). The SELECT statement returns those rows meeting the search criteria.full-text service
The SQL Server component that performs the full-text querying.function
A piece of code that operates as a single, logical unit. A function is called by name, accepts optional input parameters, and returns a status and optional output parameters. Many programming languages support functions, including C, Visual Basic, and Transact-SQL. Transact-SQL supplies built-in functions, which cannot be modified, and supports user-defined functions, which can be created and modified.
