Posted by othellomy on 03/01/07 06:25

On Feb 28, 12:20 am, "Massimo" <mast...@hotmail.it> wrote:
> The iussue:
>
> Sql 2K
> I have to keep in the database the data from the last 3 months.
> Every day I have to load 2 millions records in the database.
> So every day I have to export (in an other database as historical data
> container) and delete the 2 millions records inserted 3 month + one day ago.
>
> The main problem is that delete operation take a while...involving
> transaction log.
>
> The question are:
> 1) How can I improve this operation (export/delete)
> 2) If we decide to migrate to SQL 2005, may we use some feature, as
> "partitioning" to resolve the problems ? In oracle I can use the "truncate
> partition" statement, but in sql 2005, I'm reading, it cant be done.
> This becouse we can think to create a partition on the last three mounts to
> split data. The partitioning function can be dinamic or containing a
> function that says "last 3 months ?" I dont think so.
>
> May you help us
> thank you
>
> Mastino

Just out of curiosity, do you have to log the delete operation? You
can truncate the tables but that is not logged.

[Back to original message]