What I forgot to post was how to move existing tables to the partition -
This is achieved easily i.e. by adding a clustered index that uses the partition scheme -
USE TestDB; GO --- Step 8 : (Optional/Recommended) Create Index on Partitioned Table CREATE UNIQUE CLUSTERED INDEX IX_TestTable ON TestTable(ID) ON TestDB_PartitionScheme (ID); GO
No comments:
Post a Comment