Sql 2005 File And File Group | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sql 2005 File And File Group

Hi , My database server have 3 drive. And I plan to create data files on D drive. But I am not sure what is the difference if I just create one data file compare between I create multiple data files in the single drive ? C:
E: Thanks ,
The following two urls will give you info… http://mssqltips.com/tip.asp?tip=967
http://www.sql-server-performance.com/filegroups.asp MohammedU.
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

If you database grows out quickly and as far as the business case is concerned for accessing parts of data it is better to differentiate multiple data files in this case for the sake of performance. Otherwise having 1 data file with relevant size shoudl do the job. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
This is relevant in the cotext of this thread also. http://www.sqlskills.com/blogs/kimberly/PermaLink.aspx?guid=934f3755-5b1d-4572-a386-c6a2a0d14a9e
Roji. P. Thomas
SQL Server MVP