Tag Archives: create COLUMNs STORE indexes

How to create COLUMNSTORE INDEX in SQL Server Denali CTP1?

How to create COLUMNSTORE INDEX in SQL Server Denali? COLUMNSTORE can be created using the following syntax in SQL Server Denali. use tempdb go create table EMP ( ID int, name varchar(100) ) go CREATE COLUMNSTORE INDEX IDX_test_EID on EMP (ID) Note : COLUMNSTORE Indexes are not supported by SQL Server DENALI CTP1, if you [...]