• Another trick to move that is to partition the table with an unbounded function. Then you can rebuild the clustered index and merge the data into the new partition.

    It is a little quicker than rebuilding the table.

    Drawback is enterprise edition is required.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events