Defining Sparse Columns in SSMS
To specify a column as a sparse column using SQL Server Management Studio (SSMS), set the Is Sparse property to Yes in the column properties for the selected column (see Figure 21.3). Similarly, if a column needs to be declared as column set, set the Is Columnset property to Yes in the column properties.
FIGURE 21.3 Setting a column as a sparse column.
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
