Wiki Home

Secondary Data Files

Namespace: Wiki
In SQL Server 7, Secondary Data Files have .NDF extensions. The secondary files are used if the database is large and the primary data file has reached capacity or data is allocated to multiple secondary files for performance reasons.

You would only see a performance improvement if the secondary files were placed on other physical drives. Having multiple file alone won't do anything. Remember, there is only one set of read/write heads per drive. - Michael Levy

Category Database Structure
( Topic last updated: 1999.12.13 12:00:33 PM )