During the planning phase I found out about the new partitioning feature in SQL Server 2005 and later editions of SQL Server. It is a vast topic with several associated operations and configurations involved. In this tip I will share what I learned about partitioning, show an example to implement horizontal table partitioning along with a comprehensive list of related benefits and considerations.
The Microsoft SQL Server 2008 database software provides table partitioning to make such operations more manageable.
New author Michelle Ufford brings us an article that shows how you can replicate those partitioned tables in your environment.