Space Considerations for Various OLAP Data Types
Data types can have huge space and performance implications on large SQL tables, and there are similar implications for large OLAP cubes. We all know that double word numbers take up more space than single word numbers, but what exactly is the difference?
I have performed a simple benchmark to compare the space used of the various data types. My tests involved a
- 44 Million row fact table
- 3 measures containing values between -99 and 1039.22
- 5 dimensions
- SQL Server 2008
- Zero aggregations
Tags: design