Subject | Re: Table where we add 2 000 000 rows everydays and delete them every night |
---|---|
Author | nathanelrick |
Post date | 2012-02-13T20:46:16Z |
> First, stop worrying about the disk space being wasted. That's a problemunfortunatly i can not do so because drop the database need an exclusive access to it :(
> 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.
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
??