If you are creating an index on more than one column, index-name cannot be the same as any column in the table. table-name specifies a PROC SQL table. Indexes in PROC SQL: An index stores both the ...

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 ...