How to create COLUMNSTORE INDEX in SQL Server Denali CTP1?

Leave a comment (0) Go to comments

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.

How to create COLUMNSTORE INDEX in SQL Server Denali CTP1? sql server denali COLUMNSTORE new index in sql server create COLUMNSTORE INDEX create COLUMNs STORE indexes COLUMNSTORE INDEX sql server denali COLUMNSTORE INDEX sql server 2011 COLUMNSTORE index demo COLUMNSTORE index code COLUMNSTORE example COLUMNSTORE demo COLUMNs STORE indexes COLUMNs STORE index COLUMN STORE index sql server COLUMN STORE index denali COLUMN STORE index


COLUMNSTORE Indexes are not supported by SQL Server DENALI CTP1

This functionality is expected in upcoming releases.

EOF - How to create COLUMNSTORE INDEX in SQL Server Denali CTP1?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.