Partition

1 Partition Overview

2 Table Partition

2.1 Steps to implement table partitioning:

2.1.1 Prerequisites – Create Database with different filegroup

2.1.2 Define partition function.

2.1.3 Define partition scheme

2.2 Usage

2.2.1 Create table using above partition scheme (new)

2.2.2 Rebuild existing table using partition scheme (existing)

3 View Partition

4 Index Partition

5 FAQ

5.1 HOW TO CHECK IF THE GIVEN TABLE IS PARTITIONED?

5.2 HOW TO MANAGE or EDIT PARTITIONS?

5.2.1 PARTITION SPLIT

5.2.2 PARTITION MERGE

5.3 HOW TO COMPRESS A SPECIFIC PARTITION?