Home Forums SQL Server 2012 SQL 2012 - General table partitioning RE: table partitioning

  • March 15, 2013 at 1:03 pm

    #1597637

    ratheesh4sql (3/15/2013)

    I want to create 3 partitions Based on the List of region

    So the business rule is that you always archive and delete an entire region at a time. Odd, but if that's the rule then partitioning by region will help with archiving (which you said was the reason for partitioning in the first place)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass