Tag Archives: archiving

Archive Every Day

I regularly see questions posted online from people struggling to manage a large archive process. Often the inserts into an archive table and the deletes from the source require large amounts of resources that strain systems and block other activity. … Continue reading

Posted in Editorial | Tagged | 1 Comment

Keep Data Forever

How long do you expect to keep a piece of data in any of your databases? Chances are if you’re like me, you rarely think about it and expect that you need to store all the data perpetually. As long … Continue reading

Posted in Editorial | Tagged , | Comments Off on Keep Data Forever

Archiving Little Used Data

Someone asked the question lately about archiving old data. This person wanted to purge data from old tables and was wondering if there was a way in SQL Server 2005 to detect the last time a table was accessed. While … Continue reading

Posted in Editorial | Tagged | Comments Off on Archiving Little Used Data