How to Partition Tables with Data

In this example, the Production.TransactionHistory table in a SQL Server 2005 OLTP-database contains order transactions for the current year. All transactions for previous years are stored in the Production.TransactionHistoryArchive table. To improve the database performance, it was decided to partition the Production.TransactionHistory table by month. The easiest way is to use SQL Partition Manager.