MERGE RANGE PARTITION SQL SERVER 2005

Merging Partition states moving the data into an exiting partition or to new file group (Forward only means to next file group or Partition).   The merged partition resides in the filegroup that originally did not hold boundary_value. boundary_value is a constant expression that can reference variables (including user-defined type variables) or functions (including user-defined […]