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 |
|
KrisLewis
Starting Member
7 Posts |
 Posted - 2013-04-17 : 13:36:56
|
| Does sql server automatically determine where your tables are stored to in filegroups? I heard that after some time this can happen is this true? I am asking this because I heard that "If you add an additional file to an existing file group, you have no control over what data SQL Server will put in the new file."I also want to know how to move tables into filegroups from an existing database in production use. I am only finding information on how to do so on new tables. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-04-17 : 16:07:04
|
| You tell it where to put the tablesCREATE TABLE aTable (...) ON FileGroupNameTo move an existing table, rebuild the clustered index ON FILEGROUPNAME |
 |
|
|
|
|
|
More Filegroup Questions