Home Forums SQL Server 2008 SQL Server 2008 - General partitioning - swapping in from smaller higher grain to lower grain RE: partitioning - swapping in from smaller higher grain to lower grain

  • January 28, 2013 at 4:08 am

    #1581532

    issue resolved with a constraint on the date column. seems the engine is happy to do the swap if the constraint enforces only rows that can only go into the destination partition.