Tag Archives: COLUMNSTORE INDEX sql server denali

What is COLUMNSTORE Index in SQL Server?

What is COLUMNSTORE Index ? The SQL Server Denali (2011) launched a new type of index called the columnstore. This new index, combined with enhanced query optimization and execution features, improves data warehouse query performance by hundreds to thousands of times in some cases This can routinely give a tenfold speedup for a broad range [...]

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 [...]