Master Station Log
techno-rants, musings, misc geek writing, and occasional caffeine binges
SQL: Move Tables between FileGroups
Date: 2014-01-28 09:14:26
Here is a very good article and stored procedure on moving tables between file groups inside SQL.
Author: Roberto Stefanetti
The Stored Procedure can be found in the above link. It needs to be created in your database. Read the above link for more info!
@SourceFileGroupID = 1,
@TargetFileGroupID = 2,
@TableToMove = '[AvailableOverageMinutes]',
@MovePKAndAllUniqueConstraints = 1,
@MoveAllNonClusteredIndexes = 1