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 […]

How to create partitioned table and moving non-partitioned tables to partition schemes

 Tables Partitioning is a new feature available in SQL Server 2005, focusing on  improving performance of large database systems and Highly Transactional Databases. Partitioning feature is only available with SQLServer2005 EE and DE. This article focuses on how to create a partitioned table and moving non-partitioned tables to partition schemes. Steps: Creating the Partitioned Tables 1.Add FileGroups   USE [Database name] […]