Allocating tables to data files

[Buster49]

Are there performance improvements to be made from allocating different tables in a database to different data files. How would we work these out?

 

[SQLDenis]

Yes you will have performance improvements if the filegroups are on different drives
Syntax
create table (......
on [Filegroupname]

http://sqlservercode.blogspot.com/

 

[mrdenny]

You would need to create additional filegroups, then add new files to the database and add then to the new filegroups.

As SQLDenis said, if the files are on different drives then yes you can see a performance increase.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com