Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLLearner2
Starting Member
14 Posts |
 Posted - 2006-02-10 : 03:33:28
|
| I have a couple of file group questions...1) I have a file group for the tables and a file group for indexes. I create the tables on their file group, load the data, then create the indexes on their file group. The indexes appear to be taking up a lot more space than the actual tables themselves (each table has a clustered index and maybe one or two more indexes). Any idea why?2) In the past on older operating systems, we've had problems with large files (>2g), so I create several fixed (1g) size files to make up the different file groups. Is this advisable, or am I doing more harm than good? |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-02-10 : 09:25:35
|
| A clustered index is the table. When you create the clustered index in the index filegroup, the table data gets brought along with it. Rebuild your clustered indexes in the table filegroup.Sounds like you used FAT32. I have several databases that are entirely happy with several 20Gb files each. You don't actually lose anything performance-wise, but may find it difficult administration-wise, if you ever need to restore all the files to a new location. |
 |
|
|
|
|
|
file group questions