Home Forums SQL Server 2005 Administering .mdf question RE: .mdf question
Paul White
SSC Guru
Points: 150467
More actions
June 24, 2009 at 7:31 am
#1014635
Mani,
You can move a table from one file-group to another by rebuilding the clustered index with the ON clause.
Non-clustered indexes work the same way but would have to be done separately.
Paul
Paul WhiteSQLPerformance.comSQLkiwi blog@SQL_Kiwi