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

  • 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;-)