iqbalbutt (3/2/2015)

---

Is this the correct process to do partitioning?

Rename constraints, indexes, and table

Create table

Create clustered index using Partition Scheme

Create constraints

Back fill data from renamed table

Create non clustered indexes

Verify row counts

Drop old table