Post reply

Sql partition

  • May 18, 2011 at 5:30 am

    #237633

    can we do the single partition rebuild instead of the whole table???

  • May 18, 2011 at 7:29 am

    #1326440

    Are you talking about index rebuild? If so then yes.

  • May 18, 2011 at 9:35 am

    #1326571

    for example

    alter index myindex on [dbo].MyTable REBUILD PARTITION = 11 WITH (SORT_IN_TEMPDB = ON);

    partitioned indexes can't be rebuilt on-line btw.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 3 posts - 1 through 2 (of 2 total)

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