Is there some drawback to define SPARSE columns?

7 votes

3 answers

594 views

sql-server database-design disk-space null sparse-column

                          I have a table which has a lot of NULL values in columns. But some columns don't contain NULLs at all (although nullable). Is there some drawback to declare all of these columns as SPARSE?
                        

Asked by jrara (5393 rep)

Oct 3, 2011, 06:47 AM
Last activity: Sep 5, 2022, 10:36 AM

Is there some drawback to define SPARSE columns?

Related Questions