SQL SERVER 2005: Partitions

Two Type of Partitions:
1. Horizontal Partition
Saving rows into different tables based on data range.
2. Vertical Partition
Splitting the table into smaller tables (columns). Scattering the columns into multiple tables

Process to implement Horizontal Partition:

• Create partition function
• Create partition scheme
• Create the table/index