Moving data in and out of the partitions in SQL Server 2005

A few days back, we had written an introductory post on table data partitioning in SQL Server 2005. You can read more on that post here. In this post, we will look at the SWITCH operator and see how the data can be moved in and out of the partitions. This will become useful in designing archival sol

Read More - Register for Free Membership