tag:blogger.com,1999:blog-8305675988893866325.post3947623126535486071..comments2024-01-14T05:09:01.338-08:00Comments on Algae Education Services: Create Column store index in SQL Server 2012 : DemoAlgae Educationhttp://www.blogger.com/profile/12443040604753343283noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8305675988893866325.post-80078908218982017932015-01-15T23:05:18.185-08:002015-01-15T23:05:18.185-08:00No use!, Column store is most use when you include...No use!, Column store is most use when you include more than one column..Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8305675988893866325.post-32764576582481754022015-01-15T23:04:04.053-08:002015-01-15T23:04:04.053-08:00why are you creating non-clustered index as well a...why are you creating non-clustered index as well as column store index in same column, how it will benefit in search? <br>CREATE NONClustered INDEX [NCCSI_ID_nonClustered]<br><br>ON [CSI]<br><br>(AGE)<br><br>GO<br><br>CREATE NONCLUSTERED COLUMNSTORE INDEX [NCCSI_age_ColumnStore]<br><br>ON [CSI]<br><br>(age)Anonymousnoreply@blogger.com