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 are going to test this code in Denali CTP-1, you will get the following error message, (Screenshot is attached for your reference)
Msg 343, Level 15, State 1, Line 2
Unknown object type ‘COLUMNSTORE’ used in a CREATE, DROP, or ALTER statement.
COLUMNSTORE Indexes are not supported by SQL Server DENALI CTP1
This functionality is expected in upcoming releases.