how to find tables with either sparse or a column set column?

0 votes

1 answer

639 views

sql-server index disk-space compression sparse-column

                          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.

**Question:**

what are column set columns and how to find tables with either sparse or a column set column?

Asked by Marcello Miorelli (17274 rep)

Aug 8, 2019, 05:59 PM
Last activity: Aug 8, 2019, 06:12 PM

how to find tables with either sparse or a column set column?

Related Questions