MS SQL: Creating Partition to existing table

[plee61]

I have read articles "Data Partitioning in SQL Server 2005 - Part I & II", they are great. Is there any article on how to create partition to existing table?
Thanks
Hannah

[MAK]

This article is a series. part III will talk abt this. meanwhile you could check the syntax for dropping index.

drop index MyTable_IXC on MyTable with (Move To [Data Partition Scheme] (ID) )

[hoomanshb]

Hi
What if partition key is not a part of a clustered index?
Regards

[rmiao]

Then table is partitioned by partition key, and data in each partition are physically ordered by clustered index. We found that using clustered index as partition key has better performance.

[MAK]

http://www.databasejournal.com/featu...5---Part-V.htm