News

SQL Server 2012 has a lot of metadata about columnstore indexes. For example, sys.indexes show column store indexes as type = 6 and type_desc as ‘NONCLUSTERED COLUMNSTORE.’ There also are two new ...
Columnstore indexes are available in CTP 3 of SQL Server Code Name “Denali.” You can create a columnstore index on your table by using a slight variation on existing syntax for creating indexes. To ...