Physical Modeling › New r8 SQL Server 2008 Support in CA ERwin Data Modeler › Filtered Indexes › Sparse Columns

Sparse Columns

Use sparse columns to manage NULL data in a SQL Server 2008 database so that it consumes no physical space. Filtered indexes that are built on sparse columns provide you with improved performance. You can also utilize column sets, which allow logical grouping of all sparse columns in a table. It simplifies the generic INSERT and UPDATE of a group of sparse columns in a table.