We are using SQL Server 2008.
Our requirement is this -
We have about 4 tables related to transactions, which record orders placed by consumers, and their status of delivery.Once,the order is completed it has affect on inventory and finance. Now,these tables will become huge.So,we want to archive every 6-8 months.But,after archiving the inventory and financial calculations should not be affected.So,is partition a right option for us? how will it affect the queries? How should we approach this issue?