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" ?
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.