Post reply

Rebuild Index - Strange Problem

  • July 15, 2010 at 1:53 am

    #1193288

    SpiderDK (7/15/2010)

    Have one DB on 200+ GB and rest is small around 10-50GB, I have looked at partioning, but I'm hosted in a SAN and another LUN would be on same physical disks, so can not see any gain in spending the hours...

    Partitioning in this case wouldn't necessarily be for IO scale-out. It would be to split the table into smaller pieces (in the same filegroup event) to allow you to rebuild a partition rather than the entire table.

    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

  • July 15, 2010 at 8:16 am

    #1193503

    You have a couple of other methods to reduce down time for a rebuild, although they are more effort.

    Is this table involved in Foreign Key relationships?

    Scott Pletcher, SQL Server MVP 2008-2010

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply