Sql-server – Store Repeated Data

sql server

I have a table (Key tinyint, Value bigint).
There are a billion rows for each distinct Key value and only about 100 distinct Key values.

Is there a way to not have to store Key in the every row without breaking this up into multiple tables?

Best Answer

Try leaving it how it is, but using columnstore, perhaps. The effectiveness will depend on the style of usage, but you may find it compresses a lot better, having a useful impact.