No announcements
Found 259981 threads
-
1 Votesrebuilding clustered columnstore index
The case of rebuild of an index is a bit more involved.Answered | 5 Replies | 1375 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
Clustered columnstore index
It means clustered index on each table.Answered | 4 Replies | 1339 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
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 ...Answered | 3 Replies | 1037 Views | Created by DJ_DBA - Friday, September 18, 2015 7:54 AM | Last reply by Kalman Toth - Friday, September 18, 2015 12:54 PM -
2 Votes
Clustered Columnstore with non-clustered indexes on foreign keys
>>>The dimension tables are all rowstore with clustered indexes on the primary keys.Answered | 5 Replies | 1198 Views | Created by Richard Gaunt - Saturday, July 8, 2017 8:42 AM | Last reply by Uri Dimant - Sunday, August 27, 2017 5:43 AM -
0 Votes
Replicate on premise database to Azure SQL BUT... target clustered columnstore index
Consider disabling the columnstore index before issuing the INSERT statement, and then rebuilding the columnstore index after INSERT has completed.Answered | 2 Replies | 887 Views | Created by Willgart1 - Friday, October 21, 2016 3:09 PM | Last reply by Willgart1 - Friday, October 21, 2016 3:34 PM -
0 Votes
ALTER INDEX & columnstore index
I have corrected the ALTER INDEX page to read: Except for the REBUILD option, an xVelocity memory optimized columnstore index cannot be altered.Answered | 2 Replies | 3749 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 -
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 | 1114 Views | Created by Mourmansk - Saturday, July 16, 2016 10:09 PM | Last reply by Stan210 - Saturday, July 16, 2016 10:21 PM -
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 | 905 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
REORG of Clustered Columnstore Index during tuple mover operation
There is an excellent blog http://rusanu.com/2013/12/02/sql-server-clustered-columnstore-tuple-mover/on this topic.Answered | 1 Replies | 2980 Views | Created by hessie - Friday, May 23, 2014 8:59 AM | Last reply by Sunil Agarwal - Thursday, May 29, 2014 1:25 AM -
5 Votes
ColumnStore indexing
Hi Lin, Do you have any idea how much difference it makes if I add a non clustered columnstore say for all 30 columns vs. adding the same index but only ...Answered | 6 Replies | 1409 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
Non Clustered Columnstore Indexes and Primary/Foreign keys
" This statement is correct in that the constraint is not technically included in the non-clustered columnstore index.Answered | 5 Replies | 2313 Views | Created by asavioli - Tuesday, November 14, 2017 12:35 PM | Last reply by asavioli - Wednesday, November 15, 2017 3:47 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 | 2145 Views | Created by Stan210 - Saturday, February 13, 2016 7:45 PM | Last reply by Stan210 - Tuesday, February 23, 2016 3:55 PM -
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 | 4252 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
Rebuild cluster index
The only situation where you have to rebuild non-clustered indexes is when you remove a clustered index.Answered | 7 Replies | 1040 Views | Created by Gal1 - Wednesday, January 7, 2015 7:54 PM | Last reply by Alberto Morillo - Thursday, January 8, 2015 1:37 PM -
0 Votes
Rebuilding Clustered Indexes
Hello Two things, 1.Yes your index is fragmentated(note some conditions exists :-index-rebuild-doesnt-affect-fragmentation)- you have ...Answered | 6 Replies | 1334 Views | Created by rajesh kumar - Thursday, July 23, 2015 5:12 AM | Last reply by Rama Udaya - Monday, July 27, 2015 8: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 | 1315 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
Rebuild index
Decide Reorganize or Rebuild Indexes based on fragmentation level.Answered | 5 Replies | 1463 Views | Created by Surya.chamala - Friday, February 7, 2014 7:01 AM | Last reply by Praveen Rayan D'sa - Friday, February 7, 2014 7:38 AM -
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 | 1230 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
Boundary values are set to 0 for columnstore index segments
Hi Oleksii_Filipov, This is related to your field type, please refer to Clustered Columnstore Indexes – ...Answered | 3 Replies | 774 Views | Created by Oleksii_Filipov - Friday, April 5, 2019 7:14 PM | Last reply by Dedmon Dai - Tuesday, April 9, 2019 1:13 AM -
0 Votes
Switch partition fails with Clustered Columnstore Index
Both the table tables have Clustered Columnstore Index on these.Answered | 2 Replies | 1386 Views | Created by Suman Thota - Wednesday, April 8, 2015 8:55 PM | Last reply by Dan Guzman - Thursday, April 9, 2015 3:10 AM - Items 1 to 20 of 259981 Next ›
No announcements
