No announcements
Found 1953771 threads
-
0 VotesSQL Server Editions for Columnstore Indexes
Column store index is supported only in SQL Server Enterprise edition.Answered | 1 Replies | 1743 Views | Created by Lee Markum - Thursday, March 20, 2014 2:25 PM | Last reply by Prashanth Jayaram - Thursday, March 20, 2014 2:32 PM
-
0 Votes
Are columnstore indexes supported in SQL LocalDB?
Hello Noel, Columnstore index is an Enterprise Feature and so only available in Enterprise Edition, but not in others like LocalDB, Express or Standard.Answered | 2 Replies | 1363 Views | Created by Noel Abrahams - Monday, November 16, 2015 10:54 AM | Last reply by Noel Abrahams - Monday, November 16, 2015 11:22 AM -
0 Votes
Clustered columnstore index in sql server 2014
As databases are growing we also need to track which tables has clustered and nonclustered columnstore indexes.Answered | 2 Replies | 1103 Views | Created by DJ_DBA - Thursday, September 17, 2015 5:51 AM | Last reply by Jason_Clark03 - Thursday, September 17, 2015 6:38 AM -
0 Votes
ALTER INDEX & columnstore index
Drop and recreate the columnstore index instead.Answered | 2 Replies | 3960 Views | Created by MD_12 - Thursday, April 26, 2012 1:35 PM | Last reply by Rick Byham, Microsoft - Tuesday, May 1, 2012 7:35 PM -
2 Votes
Unable to create columnstore index on SQL Azure database
The already available preview release of v12 has Columnstore Indexes in Premium ...Answered | 4 Replies | 1476 Views | Created by Niting123 - Saturday, January 3, 2015 10:45 AM | Last reply by DE, Subhendu - Sunday, January 4, 2015 8:37 AM -
0 Votes
SQL server + disable columnstore indexes stored procedure
Limitations and Restrictions The only way is to first drop the index and re-create it afterwards.Answered | 1 Replies | 2146 Views | Created by Yvanlathem - Friday, May 15, 2015 11:57 AM | Last reply by Olaf Helper - Friday, May 15, 2015 12:02 PM -
5 Votes
ColumnStore indexing
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/ MS SQL optimization: MS SQL ...Answered | 6 Replies | 1586 Views | Created by panlondon - Friday, August 19, 2016 9:46 AM | Last reply by Uri Dimant - Wednesday, November 2, 2016 6:02 AM -
0 Votes
DBCC fails on columnstore index
Drop and recreate the columnstore index.Answered | 3 Replies | 3457 Views | Created by Staffan Olofsson - Monday, November 5, 2012 1:36 PM | Last reply by laksinfo22 - Thursday, September 1, 2016 11:16 AM -
0 Votes
performance and maintenance of columnstore indexes
You can learn about all columnstore topics here: http://www.nikoport.com/columnstore/ Hope it Helps!!Answered | 1 Replies | 1269 Views | Created by Mourmansk - Saturday, July 16, 2016 10:09 PM | Last reply by Stan210 - Saturday, July 16, 2016 10:21 PM -
1 Votes
Clustered columnstore index
Limitations.Answered | 4 Replies | 1531 Views | Created by Eldar Zeynalov - Tuesday, April 29, 2014 11:33 AM | Last reply by Kalman Toth - Tuesday, April 29, 2014 12:09 PM -
1 Votes
Can we create columnstore Index in index view
Limitations and Restrictions: "Cannot be created on a view or indexed view", so the answer is no, not possible with the current SQL Server Versions.Answered | 1 Replies | 973 Views | Created by manishcal16PPS - Friday, September 23, 2016 7:59 AM | Last reply by Olaf Helper - Friday, September 23, 2016 8:50 AM -
0 Votes
Retrieve list of columnstore indexes.
There's a column type_desc which will have values as NONCLUSTERED COLUMNSTORE in SQL ...Answered | 1 Replies | 819 Views | Created by maca128 - Wednesday, April 27, 2016 11:39 AM | Last reply by Visakh16 - Wednesday, April 27, 2016 12:18 PM -
1 Votes
rebuilding clustered columnstore index
You do not need to rebuild the index.Answered | 5 Replies | 1547 Views | Created by rpatel18 - Saturday, December 14, 2013 4:52 PM | Last reply by Sunil Agarwal (SQL) - Wednesday, March 26, 2014 4:20 AM -
0 Votes
ColumnStore Index on Secondary Replica
So if you have an index on the primary you also have the same index on the secondary, no more, no less.Answered | 3 Replies | 4420 Views | Created by Ken Powers - Thursday, August 2, 2012 6:44 PM | Last reply by PrinceLucifer - Friday, August 3, 2012 6:24 AM -
1 Votes
SQL Server Clustered Columnstore Index and Partitioning - how do they work together?
Please check this link and this has all the details about columstore index and partition..Answered | 2 Replies | 1413 Views | Created by Michael_SQL - Wednesday, September 3, 2014 11:06 PM | Last reply by Michael_SQL - Thursday, September 4, 2014 5:41 PM -
0 Votes
clustered columnstore Index on subscriber - replication - performance
If I drop the columnstore index, it would catch up soon..I tired method couple of times - like dropping index to >finish replication catch up and then recreate the ...Answered | 11 Replies | 2299 Views | Created by Stan210 - Saturday, February 13, 2016 7:45 PM | Last reply by Stan210 - Tuesday, February 23, 2016 3:55 PM -
0 Votes
Non Clustered Columnstore Indexes and Primary/Foreign keys
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-columnstore-index-transact-sql ...Answered | 5 Replies | 2460 Views | Created by asavioli - Tuesday, November 14, 2017 12:35 PM | Last reply by asavioli - Wednesday, November 15, 2017 3:47 PM -
2 Votes
SQL Server 2014 columnstore with partitioning/indexed views bug
Hi All, can any body confirm it is working in sql server 2016.Answered | 12 Replies | 3757 Views | Created by Adam PD - Thursday, June 26, 2014 6:41 AM | Last reply by manishcal16PPS - Friday, September 23, 2016 8:09 AM -
0 Votes
Generate ColumnStore Index through tsql
Hi, I have a similar problem getting the index_key information for a NonClustered Columnstore index using sp_helpindex and since my use-case ...Answered | 4 Replies | 2366 Views | Created by Dodge20 - Friday, December 20, 2013 3:45 PM | Last reply by Gowrishankar Sunder - Tuesday, June 3, 2014 12:59 AM -
2 Votes
why columnstore index doesnt improve performance
Business IntelligenceAnswered | 12 Replies | 3694 Views | Created by Omid Golban - Saturday, August 5, 2017 8:08 PM | Last reply by Will_Kong - Friday, August 25, 2017 2:48 PM - Items 1 to 20 of 1953771 Next ›
No announcements
