Partitioning in SQL Server 2008

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  September 7, 2010 at 6:15 am

  #239948

  [font="Verdana"]

  Hi All,

  We have one table with millions of records in it. This table has no partition on it. Now we want to add this existing table into the newly created partition. Can anybody suggest me on this?

  Somewhere I have been suggested that, you need to create such table newly as partitioned table, and after that you can add extra partition on it.

  However I want to know, does it possible to add existing table into the partition. If yes, what are the ways?

  Thanks in advance,

  Mahesh

  [/font]

  MH-09-AM-8694

• September 7, 2010 at 8:19 am

  This was removed by the editor as SPAM

• 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

• September 8, 2010 at 1:06 am

  This was removed by the editor as SPAM

• 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