Hello,

My question is about database partition. I know how to define a filegroup,
Partition Function, Partition scheme and do a partion on brand new table.
But my question is how can I partition a existing table without droping it!!

Thanks for help
Hooman

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/