No announcements
Found 590567 threads
-
0 VotesReplicate on premise database to Azure SQL BUT... target clustered columnstore index
You will get the following message: INSERT statement failed because data cannot be updated in a table that has a nonclustered columnstore index.Answered | 2 Replies | 919 Views | Created by Willgart1 - Friday, October 21, 2016 3:09 PM | Last reply by Willgart1 - Friday, October 21, 2016 3:34 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 | 3683 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
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 | 1069 Views | Created by DJ_DBA - Friday, September 18, 2015 7:54 AM | Last reply by Kalman Toth - Friday, September 18, 2015 12:54 PM -
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 | 2056 Views | Created by Yvanlathem - Friday, May 15, 2015 11:57 AM | Last reply by Olaf Helper - Friday, May 15, 2015 12:02 PM -
2 Votes
Clustered Columnstore with non-clustered indexes on foreign keys
This means that you can create a dummy empty nonclustered columnstore index on your table simply to enable the use of batch mode operators CREATE ...Answered | 5 Replies | 1236 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
Create a ColumnStore Index on a Partitioned Table
I'm having difficulty creating a ColumnStore index on a partitioned table.Answered | 4 Replies | 2633 Views | Created by Ken Powers - Thursday, January 24, 2013 6:31 PM | Last reply by Ken Powers - Thursday, January 24, 2013 6:59 PM -
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 – part 49 ...Answered | 3 Replies | 806 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
DBCC CheckDB with indexes and Alter index rebuild
Gal1, If your objective is to expedite the DBCC operation because of the sheer size of the db then there are other avenues you can pursue.Answered | 3 Replies | 1545 Views | Created by Gal1 - Saturday, February 15, 2014 10:27 PM | Last reply by AlliedDBA - Sunday, February 16, 2014 1:12 AM -
0 Votes
CREATE TRIGGER on table failed because you cannot create a trigger on a table with a clustered columnstore index
I will have to admit that my practical experience of columnstore is nonexistent.Answered | 4 Replies | 2082 Views | Created by panlondon - Friday, August 12, 2016 1:24 PM | Last reply by Erland Sommarskog - Monday, August 15, 2016 10:23 AM -
0 Votes
SQLPackage.exe not honoring any Options on ColumnStore index
We created a ColumnStore index with some options but when we deploy the changes, the difference script generated does not honor the options I specified.Answered | 3 Replies | 1012 Views | Created by RKD203 - Thursday, November 1, 2018 7:04 PM | Last reply by Teige Gao - Tuesday, November 6, 2018 6:40 AM -
0 Votes
REORG of Clustered Columnstore Index during tuple mover operation
// ErrorCorrectiveAction: There is no need to reorganize the specified index as it is reorganized by someone else.Answered | 1 Replies | 3017 Views | Created by hessie - Friday, May 23, 2014 8:59 AM | Last reply by Sunil Agarwal - Thursday, May 29, 2014 1:25 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 | 1333 Views | Created by Michael_SQL - Wednesday, September 3, 2014 11:06 PM | Last reply by Michael_SQL - Thursday, September 4, 2014 5:41 PM -
1 Votes
DBCC Checkdb failed
Maybe this is because you have NO_INFOMSGS, so run DBCC CHECKDB once more, but without this clause.Answered | 2 Replies | 2765 Views | Created by Youkhanis - Wednesday, January 27, 2016 1:28 PM | Last reply by Erland Sommarskog - Wednesday, January 27, 2016 10:16 PM -
0 Votes
Difference between Alter index and DBcc DBreindex
DBCC DBreindex is used in SQL server 2000 , where the Alter index(DLL) is used in SQL server 2005+Onwards.Answered | 3 Replies | 11360 Views | Created by Maheshwar Reddy - Friday, February 8, 2013 2:42 PM | Last reply by Rama Udaya - Saturday, February 9, 2013 2:06 AM -
2 Votes
Database Engine advices about missing indexes of ColumnStore type?
Although Database Engine Tuning Advisor does not give me an advice, it does not mean I should not use ColumnStore index.Answered | 6 Replies | 4524 Views | Created by Miljan Radovic - Tuesday, October 23, 2012 7:25 AM | Last reply by Miljan Radovic - Sunday, October 28, 2012 6:36 PM -
0 Votes
How DBCC INDEXDEFRAG is different than REBUILD INDEX?
Probably they should provide BOL URL of Alter Index then.Answered | 4 Replies | 692 Views | Created by Vaibhav.Chaudhari - Thursday, February 12, 2015 12:23 PM | Last reply by Shanky_621 - Thursday, February 12, 2015 2:52 PM -
1 Votes
MERGE and INSERT with COLUMNSTORE index creates crash dump - script supplied
Maybe there exists some records number limitations of Merge and Insert with COLUMNSTORE index.Answered | 4 Replies | 3944 Views | Created by uberb1oke - Tuesday, July 10, 2018 7:53 AM | Last reply by Xi Jin - Wednesday, July 11, 2018 9:52 AM -
0 Votes
creating a clustered columnstore index consumes too much ram
I've never run into this, because I've never used clustered columnstore tables, because I still can't really figure out what the deal is with them.Answered | 4 Replies | 974 Views | Created by Willgart1 - Friday, March 22, 2019 10:19 PM | Last reply by Dedmon Dai - Monday, March 25, 2019 7:37 AM -
3 Votes
Code creating clustered columnstore index while maintaining row order
The order of the rows for a table when you have a row-clustered index is purely a physical thing.Answered | 6 Replies | 894 Views | Created by Jason_86 - Tuesday, December 20, 2016 3:01 AM | Last reply by pituach - Wednesday, March 1, 2017 3:48 AM -
0 Votes
which one have good peformance columnstore Index VS Indexed View
Each kind of index has its own costs and benefits.Answered | 8 Replies | 1112 Views | Created by manishcal16PPS - Thursday, September 29, 2016 10:04 AM | Last reply by TiborK - Thursday, September 29, 2016 8:52 PM
No announcements
