HUGE Massive Ridiculous SQL 2000 file sizes! Something MUST be wrong! Right?

Question

HUGE Massive Ridiculous SQL 2000 file sizes! Something MUST be wrong! Right?

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Why do you think that is rediculous? It just means that the data has many redundant bit patterns that allow it to be highly compressed.

subs99 SSC Eights! Points: 925 More actions · Answer 2

Lynn Pettis (11/16/2009)
Why do you think that is rediculous? It just means that the data has many redundant bit patterns that allow it to be highly compressed.

Lynn - I didn't even think of that -- thanx! You may very well be correct. This is an inventory management system, and I'm not familiar with the data, so there could be a huge number of repeats, or whatever. I guess I may want to dig in and look at the actual data, do lots of GROUP BYs or whatever and see if there are a relatively few number of items that repeat a lot.

Thanx!