Hi,
I have come to know that Date Time and Decimal data types occupy fixed space even if they do not have data in them. I have a case in which i have too many Decimal and Date Time columns in my table which in most of the cases are NULL (80%). due to this, it consumes too much space. I wanted to know if there is any way to minimize this space consumption ? is it possible through Partitioning or created Detailed Tables for this?
Your help is appreciated.