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:
- create the partition scheme and partition function.
- re-create the clustered index on this new partition scheme.
Nikhil S
2010-07-21 12:21:59