MS SQL Sparse Columns
Since MSSQL 2008, we can use SPARSE columns to reduce table size, in case we have frequent NULL or 0 values.Sparse columns are not counted in the max column per table limit (1024).(I would rather check that data model, it is not usual to have more than 80 columns in a single table) see Code