Subject Re: Table where we add 2 000 000 rows everydays and delete them every night
Author nathanelrick
> First, stop worrying about the disk space being wasted. That's a problem
> for Access and similar. "Real" database managers don't suffer from that
> kind of problem. Period
>
> Based on my experience, it is usually a lot faster to drop a table and
> recreate it, than to delete all the records. I'd recommend you use that
> approach to clean it out each night.

unfortunatly i can not do so because drop the database need an exclusive access to it :(

on the other way, i thing about storing all the data on a different server / database. but now is it possible to do from stored procedure

For
Select
...
from
OtherServer:OtherDatabase TableStat
GROUP BY
xxx
DO begin
Update AggregateTable set ....
END

??