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.
