The Voice of the DBA: Bloated

There was an article about databases getting bloated with tons of older data that's not needed. I've actually argued this point with various employers I've had and the need to archive and remove older data. Usually without success. The problems that I've seen is most applications aren't well suited to dealing with archived data. So if I remove a set of data, say everything older than 60 days, the data is gone. There's no option to search archived data, or even a note to ask someone to look for it. And if I just move this data to another database, I might get some performance benefits, but I'm not doing anything about the tremendous amount of data I'm creating or accumulating. Read the rest of Bloated at SQLServerCentral.com

Mevio | April 14, 2008

Tags:. .another. .thats. .point. .performance. .move