Home Forums SQL Server 2005 Administering Deleting records from a table that is actively written too.. RE: Deleting records from a table that is actively written too..

  • August 8, 2012 at 1:50 am

    #1522984

    Lynn Pettis (8/7/2012)

    Gianluca Sartori (8/7/2012)

    A sliding window partitioning strategy could help here.

    Dan Guzman has a couple of nice posts on the subject:

    http://weblogs.sqlteam.com/DANG/archive/2008/08/30/Sliding-Window-Table-Partitioning.aspx

    http://weblogs.sqlteam.com/dang/archive/2008/09.aspx

    Setting up the partition scheme and rebuilding your indexes on the partition scheme can be done online if you have Enterprise Edition.

    Hope this helps

    Gianluca

    You need Enterprise Edition for table partitioning anyways.

    Oh, sure. This is something I didn't think about. :blush:

    -- Gianluca Sartori