Many databases have large tables with hundreds of millions of rows. However, many of these tables are simply keeping a log or history data that can be archived and kept outside the user database in a special archive database.
2013-07-10
37,909 reads
Many companies now have a requirement to keep data for long periods of time. While this data does have to be available if requested, it usually does not need to be accessible by the application for any current transactions. Data that falls into this category are a good candidate for archival.
2012-10-22
3,934 reads
A hopefully useful script to delete old files, not just backups, and make use of the archive bit.
2009-01-02 (first published: 2008-12-09)
2,450 reads
The post The pros and cons of self-service BI: What every industry leader should...
By Steve Jones
As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
Hi, i considered power bi with embedded for this. Not a big fan...
A digital marketing agency USA can transform your business by building an effective online...
Hi everyone I am trying to implement parallelism in my SSIS package. There are...
Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)
See possible answers