In SQL Server, you can use the ALTER PARTITION FUNCTION
to merge two partitions into one partition.
To do this, use the MERGE RANGE
argument, while providing the boundary value of the partition to drop.
This operation drops the partition and merges any values that exist in the partition into a remaining partition.
Continue reading