SQL Server Training | Tutorials | How to's

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.