Home Forums SQL Server 2005 Administering Move a clustered index from one filegroup to another on a production database RE: Move a clustered index from one filegroup to another on a production database
Bhuvnesh
SSC Guru
Points: 59351
More actions
November 7, 2012 at 3:46 am
#1556699
you can also opt SORT_IN_TEMPDB = ON to divert the IO load to tempdb too
-------Bhuvnesh----------I work only to learn Sql Server...though my company pays me for getting their stuff done;-)