Building an index on the rows that have non-null values in a sparse column would maximize the benefits. Filtered Indexes can be created using non-sparse columns too. Maybe this will settle the NULL vs ...

You can also create filtered indexes on sparse columns so that only the non-NULL values are saved in the index. An example of this is where a Product table supports many products but only a small ...