Specifies whether the column can accept NULL values. Columns that do not allow NULL values can be added only if they have a default specified. If the new column allows NULL values and no default is ...

When you alter the attributes of a column and an index has been defined for that column, the values in the altered column continue to have the index defined for them. If you drop a column with the ...

Applies to: [!INCLUDE sql2008-md] and later versions. Specifies index padding. The default is OFF.. ON. The percentage of free space that is specified by FILLFACTOR is applied to the ...

Users should have no problem creating a secondary index (also referred to as non-clustered indexes or NCI) on a column store table (also referred to as clustered column store indexes or CCI).