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 20.3). Similarly, if a column needs to be declared as column set, set the Is Columnset
property to Yes in the column properties.
Get Microsoft® SQL Server 2012 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.