Switching data in and out of a SQL Server 2005 data partition

One of the challenges of working with large datasets or datasets that become stale is the need to move large chunks of data in and out of your tables. This can be done with large INSERT and DELETE statements or by using views, but with SQL Server 2005 data partitioning makes this task much easier t

Read More - Register for Free Membership