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 [...]
Tag Archives: new index in sql server
How to create COLUMNSTORE INDEX in SQL Server Denali CTP1?
Posted by Mahesh Gupta on December 6, 2010
0 comments
