Browsing All Posts filed under »Sparse Columns«

Sparse Columns

January 20, 2008


SQL Server 2008 (“Katmai”) introduces something called Sparse Columns. What this allows you to do is to define a column that rarely contains data. When this is defined the column does not take up any space until it is used. An example of the code required to define the column is shown below. CREATE TABLE […]