Hello Hooman,

The most practical way is to use SSIS to populate the partitions or
T-SQL Insert Statement.

Try this:

1. Create the new table with a temporary name ie PartitionTable_temp,
2. Use SSIS to transfer the data from the source table to
PartitionTable_temp,
3. Drop your source table and rename the PartitionTable_temp to the
source.

Hopefully you have enough disk space.

Hope this helps,

Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/