F


Field

A column of a table typically used to store an indivisible element of an entity.

Filegroup

A logical means of controlling the placement of database objects on a file or set of files.

Filegroup backup

A special type of backup specifically designed for very large databases, terabytes in size, that backs up small sections of the database.

Fixed database role

A role that is created by SQL Server 2005 in each database with a set of permissions that are predetermined and cannot be altered. Users can be added to one or more fixed database roles.

Fixed server role

A predefined role at the server level that is used to control administrative access to the SQL Server instance.

Foreign key

Used to maintain relationships between entities. Implemented as a field in a child table that has a corresponding primary key that it references.

Foreign key constraint

A database object (data integrity mechanism) that maintains referential integrity by establishing and enforcing a link between the data in two tables.

Fragmentation

A doubly linked series of pages whose logical order does not equal the physical order.

Full backup

A backup of the entire database that includes the database files, the locations of those files, and the portions of the transaction log (from the LSN recorded at the start of the backup to the LSN at the end of the backup). This is the first type of backup you will need to do in any backup strategy because all the other backup types depend on the existence of a full backup. A full backup is sometimes called a baseline in a backup strategy.

Full recovery model

This model fully logs all transactions and retains all the transaction log records until after they are backed up. In the Enterprise Edition of SQL Server 2005, the full recovery model allows a database to be recovered to the point of failure, assuming that the tail of the log has been backed up after the failure.

Fuzzy grouping transformation

The SSIS transformation to use if you do not have an established set of master data but are merely combining a variety of data sources for a “best fit.”

Fuzzy lookup transformation

The SSIS transformation to use if you already have a well-established set of master data and are trying to match another source of data against this standardized set.



MCITP Administrator. Microsoft SQL Server 2005 Optimization and Maintenance Study Guide (70-444)
MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
ISBN: 0470127457
EAN: 2147483647
Year: 2004
Pages: 146

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net