from the error message below:
A compressed index is not supported on table that contains sparse columns or a column set column
as I was rebuilding an index and changing the
data_compression to page
This was after making good use of sparse column or compression data wonderful scripts.
column set columns and how to find tables with either sparse or a column set column?