<div>
You can convert this as a partition(daily/monthly) tables and archive the oldest partitions to the other table. In this case you won't lose data also you keep the main table in control.
</div>


You can convert this as a partition(daily/monthly) tables and archive the oldest partitions to the other table. In this case you won't lose data also you keep the main table in control.

<div>
This sounds like it will work; do you have any detail or where I can get more information on how to archive the oldest partitions to the other table?<br />
<br />
Thanks!!
</div>


This sounds like it will work; do you have any detail or where I can get more information on how to archive the oldest partitions to the other table?

Thanks!!

<div>
<div class="content wysiwyg-content">
I have an SQL database that has an activity table within that records all activity to the database. &nbsp;As you can image this table grows pretty fast. &nbsp;When we first got the database it was at about 3gig and after a year and half it is now at 13gig. &nbsp;I’ve talked with the vendor and they suggest that I periodically delete the old records and have no other options. &nbsp;My problem with that is that this is an HR database and I don’t want to lose any data in case they need to reference it. &nbsp; &nbsp;Is there any best practice on how to handle that table in SQL?
</div>
</div>


I have an SQL database that has an activity table within that records all activity to the database.  As you can image this table grows pretty fast.  When we first got the database it was at about 3gig and after a year and half it is now at 13gig.  I’ve talked with the vendor and they suggest that I periodically delete the old records and have no other options.  My problem with that is that this is an HR database and I don’t want to lose any data in case they need to reference it.    Is there any best practice on how to handle that table in SQL?

Table Growth in SQL

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.