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

  • November 7, 2012 at 4:44 am

    #1556719

    sanket kokane (11/7/2012)

    Bhuvnesh (11/7/2012)

    DesmoShane (11/6/2012)

    will the resulting non-clustered indexes will they be rebuilt automaticaly and be an online operation

    YEs. any change to the cluster keys forces all the non-clustered indexes to be rebuilt after the new clustered index has been created. but try to perform this on off-peak hours

    I don't thinks so.

    look at the Paul's blog ... Myth No.3

    http://www.sqlskills.com/blogs/paul/post/Search-Engine-QA-19-Misconceptions-around-index-rebuilds-%28allocation-BULK_LOGGED-mode-locking%29.aspx

    thanks

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)