Reindexing a partition alone

• itsvikrams

  SSC Enthusiast

  Points: 104

  More actions

  April 21, 2009 at 4:04 am

  #130723

  I have a scenario in which i need to reindex two partition alone.

  Partition are done on an monthly basis. in need to reindex curent month and previous month alone that is 2009_04 - April 2009_03-March....

  Any help is appreciated...

• Satish Nagaraja

  SSCrazy

  Points: 2632

  More actions

  April 21, 2009 at 4:49 am

  #981298

  This article states the DBCC commands are aware of partitions and can be applied on partitions but does not say how to do it

  http://hi.baidu.com/peacescott/blog/item/73e4b634c610243d5ab5f505.html

  Cheer Satish 🙂

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  April 21, 2009 at 4:51 am

  #981300

  Look up ALTER INDEX in Books Online.

  When using the PARTITION option you can define which partition to rebuild or reorganize.

  [font="Verdana"]Markus Bohse[/font]

• Satish Nagaraja

  SSCrazy

  Points: 2632

  More actions

  April 21, 2009 at 4:52 am

  #981301

  Also refer to this post in forum

  http://www.sqlservercentral.com/Forums/Topic474364-146-1.aspx

  -Sat

  Cheer Satish 🙂