Henrik,

Have you experimented with data compression, both at the row and page level?

I'm created significant storage efficiency improvements at the page level but those results involved a lot of character data.

I've never experimented with data containing a lot of numerics. You might experiment with compression, if you haven't already, at both the row and page level, to see what storage efficiency improvements you can obtain.

A word of warning: Don't do the experiment on LARGE indexes. The experiment will rebuild the index in the TempDB to report the efficiency gained and this can consume a lot of TempDB space. Try it on smaller indexes first.

Gail