Partitioning in SQL Server 2008

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  September 7, 2010 at 11:52 pm

  #1217727

  [font="Verdana"] Thanks for you updation.

  However we already do have Clustered Index on our table. So can we add partition with Alter Statement?

  Thanks again,

  Mahesh[/font]

  MH-09-AM-8694

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  September 7, 2010 at 11:52 pm

  #1217728

  [font="Verdana"] Thanks for your updation.

  However we already do have Clustered Index on our table. So can we add partition with Alter Statement?

  Thanks again,

  Mahesh[/font]

  MH-09-AM-8694

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  September 8, 2010 at 2:16 am

  #1217771

  [font="Verdana"]

  is the clustered index mentioned above on the column you wish to use to partition?

  No, we have clustered index on ID column. recently we have added one more column, called IsArchive, where we will store values either 1 or 0. And on this column we want to use partition.

  Any suggestions?

  Thanks,

  Mahesh

  [/font]

  MH-09-AM-8694