views:

29

answers:

1

I have a table that has more than 50 million records and which does not have any partition. But now i want to add a partition scheme to this table. This table has a primary key. But i want to partition it using another int column. How can i do it?

+1  A: 
  1. create the partition scheme and partition function.
  2. re-create the clustered index on this new partition scheme.
Nikhil S