Tag: Partitioning
-
SQL Server Partitioning Data Movement
Introduction This is a continuation to the partitioning overview post to help explain how data movement is performed using Alter Partition with Merge and Split Commands. Getting Started In order to move data in or out of a partitioned object the part of the object that needs to be moved must reside on the same file…
-
SQL Server Partitioning Overview
Introduction This is a guide to help explain partitioning setup; which although introduced way back in SQL 2005 is still an area which throws up a lot of questions. Requirements First off you will need Enterprise SQL Server in your production environment, or alternatively you can explore this feature in SQL Developer edition. Getting Started…