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 ...