Steps for Creating Partition

• Identify the List of Tables to be Partitioned
• Determine Partitioning Keys in the Tables and re-align Indexes if required
• Determine No. of Partition for each table or group of Tables
• Create Filegroups (both on Database and Filesystem)
• Create Partition Function
• Create Partition Scheme
• If new Tables, Create tables on Partition Scheme
• If existing Tables, Create Indexes with DROP INDEX...WITH (MOVE TO...) syntax