On 2017-12-29 13:41, Stephen Russell wrote:
My company won't get rid of transactional data and the size of the 4 GL tables that are in my way is roughly 600 gigs. Finding specific data in them that is outside the scope of my indexes takes way too long. It also takes additional time to do a restore as well. In 2018 we are porting to an upgrade on a new data server so it will take each test more time to restore as well.
To me, IRS data demands past 7 years. I'll keep 8 and remove 3 years of older transactions now because we already have them in the DW as well.
Welcome to my monthly fight. :)
Didn't you guys say you're moving things to "The Cloud" ?