Sparse Columns Part 2

In last article we look into what is sparse columns and how to use it. You can visit Part 1 from here
Sparse Column Part 1

Rules for creating sparse columns.

  • Sparse Column must be nullable.
  • you cant assign default values to sparse columns
  • You cant make sparse column as identity or rowguidcol.
  • computed columns can not be sparse
  • You can not create clustered index/Unique Index/Primary Index on a sparse column.
  • You can have 30000 columns as sparse column in a table.
  • You can create 1000 index in table with sparse columns.
  • A table with sparse columns can not be compressed
  • Tables Types cannot use sparse columns
  • Sparse columns can not be used with merge replications

No comments:

Post a Comment

Popular Posts