No announcements
Found 505696 threads
-
0 Votesperformance and maintenance of columnstore indexes
You can learn about all columnstore topics here: http://www.nikoport.com/columnstore/ Hope it Helps!!Answered | 1 Replies | 1262 Views | Created by Mourmansk - Saturday, July 16, 2016 10:09 PM | Last reply by Stan210 - Saturday, July 16, 2016 10:21 PM
-
2 Votes
why columnstore index doesnt improve performance
While not it's an answer but a columnstore index does not necessarily index all columns so if you actually have just one column that isn't part of your columnstore ...Answered | 12 Replies | 3676 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
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 | 2287 Views | Created by Stan210 - Saturday, February 13, 2016 7:45 PM | Last reply by Stan210 - Tuesday, February 23, 2016 3:55 PM -
0 Votes
ALTER INDEX & columnstore index
Drop and recreate the columnstore index instead.Answered | 2 Replies | 3945 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 | 1578 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 | 4413 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
rebuilding clustered columnstore index
You do not need to rebuild the index.Answered | 5 Replies | 1539 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
DBCC fails on columnstore index
Msg 5283, Level 16, State 1, Line 2 The Cross Rowset check on columnstore index object ID 912722304, index ID 3, partition ...Answered | 3 Replies | 3448 Views | Created by Staffan Olofsson - Monday, November 5, 2012 1:36 PM | Last reply by laksinfo22 - Thursday, September 1, 2016 11:16 AM -
2 Votes
Clustered Columnstore with non-clustered indexes on foreign keys
The below trick may increase the performance of the ...Answered | 5 Replies | 1289 Views | Created by Richard Gaunt - Saturday, July 8, 2017 8:42 AM | Last reply by Uri Dimant - Sunday, August 27, 2017 5:43 AM -
1 Votes
Clustered columnstore index
Limitations.Answered | 4 Replies | 1520 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 | 808 Views | Created by maca128 - Wednesday, April 27, 2016 11:39 AM | Last reply by Visakh16 - Wednesday, April 27, 2016 12:18 PM -
0 Votes
SQL Server Editions for Columnstore Indexes
Column store index is supported only in SQL Server Enterprise edition.Answered | 1 Replies | 1734 Views | Created by Lee Markum - Thursday, March 20, 2014 2:25 PM | Last reply by Prashanth Jayaram - Thursday, March 20, 2014 2:32 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 | 966 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
alter statement failed because the operation cannot be performed online on a table with a columnstore index
The first version of Columnstore Index in SQL Server 2012 made a table read-only, this has change version by version, and so I guess also the limitation will be reduced version by ...Answered | 4 Replies | 1954 Views | Created by princerastogi - Thursday, November 30, 2017 1:22 PM | Last reply by princerastogi - Monday, December 11, 2017 8:01 AM -
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 | 2453 Views | Created by asavioli - Tuesday, November 14, 2017 12:35 PM | Last reply by asavioli - Wednesday, November 15, 2017 3:47 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 | 1355 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 | 1092 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
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 | 2359 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
Unable to create columnstore index on SQL Azure database
The already available preview release of v12 has Columnstore Indexes in Premium ...Answered | 4 Replies | 1469 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
Fragmentation levels of all the clustered columnstore indexes in a database
QUOTE: " A few specifically interesting Dynamic Management Views (DMVs) are delivered with SQL Server 2014 for Clustered Columnstore Indexes.These views help us ...Answered | 3 Replies | 1123 Views | Created by DJ_DBA - Friday, September 18, 2015 7:54 AM | Last reply by Kalman Toth - Friday, September 18, 2015 12:54 PM - Items 1 to 20 of 505696 Next ›
No announcements
