How do I partition existing table in SQL Server 2005/08? I couldn't find a better clue on it.
Here is a full article on how to do this. (Create table, insert data, then partition)
Trick is to move the table to the new partition.
DROP INDEX MyTable_IXC ON MyTable WITH (Move To [Data Partition Scheme] (ID) )
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With