SQL Server Performance Forum – Threads Archive
filegroups
hOW would i place a single table having 10 milions rows into 3 separatefilegroups? Atul A Sathe
Why do you want to seperate the data?
What kind of performance issues you’re having? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
How to place an existing table on a different filegroup (Enterprise Manager)
To place an existing table on a different filegroup 1.Expand a server group, and then expand a server.
2.Expand Databases, expand the database in which the table belongs, and then click Tables.
3.In the details pane, right-click the table, and then click Design Table.
4.Right-click any column, and then click Properties.
5.On the Tables tab, in the Table Filegroup list, select the filegroup on which to place the table.
6.Optionally, in the Text Filegroup list, select a filegroup on which to place any text, image, and ntext columns
Dinesh It will create the new filegroup and place the new data on to the defined filegroup or default filegroup. I believe Atul wanted to seperate the data physically to the different filegroups, I believe only by using DTS or BCP you can seperate the data and divide the filegroup accordingly. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
IMO 10 million rows is not that big, so I don’t think you need partitioning. Have you tried to put indexes in separate file group placed on separate physical drive? I agree with Satya that we could help better if you describe performance issues you have.
]]>