trying to do some diskspace maintenance on one of our larger DB's made up of 6 DB files across 2 file groups and found this piece of code:

Code:
exec sp_help MY_TABLE -- to show which FG the data is on 
ALTER TABLE MY_TABLE DROP CONSTRAINT PK_MY_TABLE WITH (MOVE TO [SECONDARY])
GO
ALTER TABLE MY_TABLE ADD CONSTRAINT PK_MY_TABLE PRIMARY KEY(myTableId)
GO
exec sp_help MY_TABLE
was able to move 1MM records in 4m 20s