When performing a merge operation, the partition for the boundary value specified in the ALTER PARTITION FUNCTION ... Information For more information about merging partitions, see aALTER PARTITION FUNCTION ( Transact-SQL)a in SQL Server Books Online. ... The new partition is created on the filegroup designated as the next filegroup in each partition scheme based on the partition function.
|Title||:||Transact-SQL Programming with SQL Server 2005 and 2008|
|Author||:||Rigoberto Garcia PhD|