CODEWITHSUNDEEP
sqlsql-serverdatabaseperformancet-sql
user2989981
user2989981

Reputation: 89

Can't create columnstore index

When I try to create a columnstore index using the following syntax

create nonclustered columnstore index indx1 on table1 (row1, row2)

I get an error message on the 'columnstore' keyword saying incorrect syntax near columnstore. Expecting INDEX, and another error message on the 'row1' saying incorrect syntax, expecting "(", or SELECT

I am in SQL server 2012. I have tried this on temp tables and permanent tables, and still get these errors. What is going wrong?

thanks

Upvotes: 0

Views: 1047

Answers (1)

usr
usr

Reputation: 171178

SQL 2008

This server version does not support columnstore indexes. The SQL that you write runs on the server. All the client does is transmit the SQL string over the network. You could send command with telnet if you wanted to.

Maybe this is your misunderstanding: In many languages code is compiled into some build output like a binary that can run anywhere. With SQL, the text is sent to the server and runs there.

Upvotes: 2

Related Questions