No announcements
Found 294901 threads
-
4 VotesColumnstore Index in read_only filegroup prevents CheckDB
You can vote for work on this bug ...Unanswered | 5 Replies | 3746 Views | Created by Peter Vandivier (viagogo) - Thursday, February 22, 2018 9:42 PM | Last reply by Peter Vandivier - Wednesday, January 16, 2019 9:18 AM
-
0 Votes
Problem with restore read_only filegroup
John Sansom, you are right, but in my example i try to restore read_only filegroups (B1 and B2) and i don't changed this.Answered | 7 Replies | 7545 Views | Created by greendraw - Tuesday, July 12, 2011 8:32 AM | Last reply by John Sansom - Wednesday, July 13, 2011 7:22 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 | 3459 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 | 3962 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 | 1587 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 | 4420 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 | 1270 Views | Created by Mourmansk - Saturday, July 16, 2016 10:09 PM | Last reply by Stan210 - Saturday, July 16, 2016 10:21 PM -
0 Votes
DBCC CheckDB with indexes and Alter index rebuild
Rebuilding indexes does not necessary mean there is no possibility of a corruption.Answered | 3 Replies | 1619 Views | Created by Gal1 - Saturday, February 15, 2014 10:27 PM | Last reply by AlliedDBA - Sunday, February 16, 2014 1:12 AM -
1 Votes
Clustered columnstore index
Limitations.Answered | 4 Replies | 1533 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
Read_Only and Read_Write File Groups in Same Database
When a Filegroup is marked as Read-only, SQL Server will not bother with Page or Row locks on the tables or indexes contained in them.Answered | 4 Replies | 1097 Views | Created by abeljda - Thursday, June 12, 2014 5:09 PM | Last reply by RAJU RG - Thursday, June 12, 2014 10:37 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 | 820 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 -
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 | 974 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
SQL Server Editions for Columnstore Indexes
Column store index is supported only in SQL Server Enterprise edition.Answered | 1 Replies | 1744 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
How to recreate indexes on a different filegroup
And that clustered indexes should be on the data filegroup right?Answered | 7 Replies | 6493 Views | Created by ZychoFlow - Sunday, December 12, 2010 4:01 PM | Last reply by Dan Guzman - Tuesday, December 14, 2010 3:14 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 | 1364 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
Indexes to a Different Filegroup
Hello, Do you know that if you have 2 filegroups in two different drives and you move a clustered index ...Answered | 3 Replies | 1087 Views | Created by Vinod Mallolu - Monday, March 23, 2015 11:31 AM | Last reply by Alberto Morillo - Monday, March 23, 2015 12:18 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 | 1104 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
why columnstore index doesnt improve performance
Columnstore index is designed for analytics workload.Answered | 12 Replies | 3696 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
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 | 2368 Views | Created by Dodge20 - Friday, December 20, 2013 3:45 PM | Last reply by Gowrishankar Sunder - Tuesday, June 3, 2014 12:59 AM - Items 1 to 20 of 294901 Next ›
No announcements
