Merge Range - Partition in SQL Server - Part 4
Click here to Subscribe to IT PORT Channel : / @itport28
Drops a partition and merges any values that exist in the partition into one of the remaining partitions. RANGE (boundary_value) must be an existing boundary value, into which the values from the dropped partition are merged. The filegroup that originally held boundary_value is removed from the partition scheme unless it is used by a remaining partition, or is marked with the NEXT USED property.
Alter Partition Function Part_Function_Name
Merge Range ()