Development

SQL Server – Columnstore Index creation error: A columnstore index cannot have INCLUDED columns

Hi friends, in my previous blog we learnt that sparse column cannot be part of columnstore index. In this blog we will discuss another limitation of columnstore index which is INCLUDE clause is not allowed while creating columnstore index. Now, let’s create a test table and then we will try to create a nonclustered columnstore… Continue reading SQL Server – Columnstore Index creation error: A columnstore index cannot have INCLUDED columns

Development

SQL Server – Columnstore Index creation error: A columnstore index cannot be created on a SPARSE column

Hi friends, as we know that in SQL Server 2012 a new feature Columnstore index was introduced which made a great change in area of performance optimization like reducing I/O. From SQL server 2012 to 2016 there were many changes made in columnstore index. In SQL Server 2012 only nonclustered columnstore index were introduced. In… Continue reading SQL Server – Columnstore Index creation error: A columnstore index cannot be created on a SPARSE column