Partitioning of tables in SQL Server

Partition means splitting into pieces. When table grows huge and it becomes difficult to manage it, even if indexes on it are getting tampered we can opt for partitioning such huge tables.

We can split huge tables into small tables based on ‘Range’ of values. By specifying upper and lower limit values we can split tables into small pieces. This helps in increasing performance and even index maintenance also becomes easier. We can partition indexes too, only Clustered index can’t be partitioned.

Partitioned tables can be kept in different file groups. So same table can be partitioned and kept in different file groups and they can be maintained in different locations. By partitioning we can deviate set of values to store in a particular part of table

Links …