Sparse columns not showing any savings

Sparse columns not showing any savings

References

Reference NO 1

http://stackoverflow.com/questions/15186448/sparse-columns-not-showing-any-savings

Reference NO 2

http://technet.microsoft.com/en-us/library/cc280604.aspx

Reference NO 3

http://www.sqlservercentral.com/Forums/FindPost1425940.aspx

Reference NO 4

https://www.simple-talk.com/sql/t-sql-programming/null-friendly-using-sparse-columns-and-column-sets-in-sql-server/

Reference NO 5

http://databaseexpertise.com/sql-server/why-do-you-use-sparse-columns-by-abi-chapagai/

Reference NO 6

http://sqlhints.com/2011/11/12/sparse-columns-in-sql-server-2008/

Reference NO 7

http://dba.stackexchange.com/questions/47913/should-i-add-a-column-or-1-1-table-if-property-is-usualy-null

Reference NO 8

http://www.sqlskills.com/blogs/paul/sql-server-2008-sparse-columns/