• I think several things were missing from the article:

    1) You should cover the need to handle foreign keys to the PK

    2) You should cover a best practice of dropping the NC indexes prior to dropping the C index, then recreating same after the move.

    3) You should DEFINITELY not recommend shrinking a database!!! The fragmentation caused by this is horrendous, and the database will simply fragment more (and at the OS file level) as it grows back up.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service