No announcements
Found 590593 threads
-
0 VotesDBCC fails on columnstore index
Drop and recreate the columnstore index.Answered | 3 Replies | 3262 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
ALTER INDEX & columnstore index
Drop and recreate the columnstore index instead.Answered | 2 Replies | 3759 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 -
5 Votes
ColumnStore indexing
This is in terms of index updating cost and also the optimiser choosing the best option to use from a columnstore of 30 columns vs 5 columns.Answered | 6 Replies | 1417 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
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 | 4261 Views | Created by Ken Powers - Thursday, August 2, 2012 6:44 PM | Last reply by PrinceLucifer - Friday, August 3, 2012 6:24 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 | 1122 Views | Created by Mourmansk - Saturday, July 16, 2016 10:09 PM | Last reply by Stan210 - Saturday, July 16, 2016 10:21 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 | 1235 Views | Created by Noel Abrahams - Monday, November 16, 2015 10:54 AM | Last reply by Noel Abrahams - Monday, November 16, 2015 11:22 AM -
1 Votes
Clustered columnstore index
Limitations.Answered | 4 Replies | 1349 Views | Created by Eldar Zeynalov - Tuesday, April 29, 2014 11:33 AM | Last reply by Kalman Toth - Tuesday, April 29, 2014 12:09 PM -
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 | 656 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 | 1384 Views | Created by rpatel18 - Saturday, December 14, 2013 4:52 PM | Last reply by Sunil Agarwal (SQL) - Wednesday, March 26, 2014 4:20 AM -
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 | 820 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
Switch partition fails with Clustered Columnstore Index
Both the table tables have Clustered Columnstore Index on these.Answered | 2 Replies | 1391 Views | Created by Suman Thota - Wednesday, April 8, 2015 8:55 PM | Last reply by Dan Guzman - Thursday, April 9, 2015 3:10 AM -
0 Votes
SQL Server Editions for Columnstore Indexes
Column store index is supported only in SQL Server Enterprise edition.Answered | 1 Replies | 1579 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
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 | 2228 Views | Created by Dodge20 - Friday, December 20, 2013 3:45 PM | Last reply by Gowrishankar Sunder - Tuesday, June 3, 2014 12:59 AM -
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 | 2151 Views | Created by Stan210 - Saturday, February 13, 2016 7:45 PM | Last reply by Stan210 - Tuesday, February 23, 2016 3:55 PM -
2 Votes
SQL Server 2014 columnstore with partitioning/indexed views bug
2) You create the view index after the columnstore index.Answered | 12 Replies | 3637 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
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 | 914 Views | Created by DJ_DBA - Thursday, September 17, 2015 5:51 AM | Last reply by Jason_Clark03 - Thursday, September 17, 2015 6:38 AM -
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 | 1347 Views | Created by Niting123 - Saturday, January 3, 2015 10:45 AM | Last reply by DE, Subhendu - Sunday, January 4, 2015 8:37 AM -
2 Votes
why columnstore index doesnt improve performance
Columnstore index is designed for analytics workload.Answered | 12 Replies | 3397 Views | Created by Omid Golban - Saturday, August 5, 2017 8:08 PM | Last reply by Will_Kong - Friday, August 25, 2017 2:48 PM -
0 Votes
Non Clustered Columnstore Indexes and Primary/Foreign keys
The phrase "but the constraints cannot be included in the nonclustered columnstore index.Answered | 5 Replies | 2320 Views | Created by asavioli - Tuesday, November 14, 2017 12:35 PM | Last reply by asavioli - Wednesday, November 15, 2017 3:47 PM -
0 Votes
More columnstore woes
You've identified that there is a cardinality estimate issue - and I'd be curious to see the histograms (via DBCC SHOW_STATISTICS) of the indexes and ...Answered | 1 Replies | 1416 Views | Created by Adam PD - Wednesday, May 8, 2013 1:38 AM | Last reply by Joseph Sack - Thursday, May 9, 2013 1:14 PM - Items 1 to 20 of 590593 Next ›
No announcements
