Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Sub partitions RE: Sub partitions

  • September 21, 2013 at 2:53 am

    #1652122

    Welcome to 'it depends' 🙂

    If you want to do fast loads and fast deletes (switch partitions in/out), then partition. If you want to do index maintenance at the partition level, then partition. If not, then probably no need to partition

    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