Questions tagged [columnstore]

For questions about column-oriented storage and access mechanisms in databases. Although the term "columnstore" itself is used by Microsoft and MariaDB for their respective implementations, you should use this tag for questions about other vendors' technologies (e.g. IBM Db2 column-organized tables) and for questions about the technology in general, not specific to a particular vendor.

17 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
248 views

Table design pattern that can support partitioning, clustered columnstore index, and spatial data?

I am designing a spatial database schema for SQL Server 2016 with a table that is going to hold a large amount of rows (50+ billions, increasing by 50+ millions per day). Requirements: Spatial ...
2
votes
0answers
59 views

Is there impact on query execution as more partitions are added to a table?

We are looking to heavily use partitioned tables in our data warehouse environment. We are looking to take advantage of fast partition switching as well as partition elimination during analytical ...
2
votes
0answers
138 views

Column Store Indices versus Dimensional Tables

I have a Data Warehouse and want to think ahead one year when I may get a database update allowing me to use column store indices. My dimensional tables are mostly junk dimensions containing columns ...
2
votes
0answers
563 views

Best Practice to update columnstore indexed tables

I have a table with aprox. 22 Bn rows, for each month I have made one partition that and each partition has two data files. I created the columnstore index on this table and the performance ...
1
vote
1answer
71 views

What does column family-oriented datastore mean in practice

I was reading this article about HBase. Within it, the storage format of HBase is described: HBase is referred to as a column family-oriented data store. It’s also row-oriented: each row is indexed ...
1
vote
0answers
67 views

Why are pages being removed from the buffer cache

I have an test environment with SQL Server 2016 SP1 installed. My machine has 32GB of RAM and I give 30GB to SQL Server. I have 2 databases in my server - BGD and, BGD_Mem. The second one contains ...
1
vote
0answers
523 views

SQL Server 2016 partitioning with columnstore

Environment is SQL 2016/SP1/CU1 Enterprise on Windows 2012 R2 Standard, and I'm running tests on using paritioning in combination with clustered columnstore. For one large table (300 million rows), ...
1
vote
1answer
34 views

How to indicate what will be measured with a NONCLUSTERED COLUMNSTORE INDEX?

I am new to columnstore INDEXes. But I am fairly sure I need one now. Here is my setup. I have a table that has the columns ApplicationId, GroupId and TimeInMilliseconds. I am going to want to run ...
1
vote
0answers
606 views

Clustered Columnstore Index on Table with Foreign key

Using SQL Server 2014, I am trying to create a clustered columnstore index on a table which is referenced by a foreign key. This is the syntax I am using CREATE CLUSTERED COLUMNSTORE INDEX ...
1
vote
0answers
724 views

Failed to allocate reserved pages: FAIL_RESERVED_PAGE_ALLOCATION

Last night I received the error on one of my servers of: Failed to allocate reserved pages: FAIL_RESERVED_PAGE_ALLOCATION 2047 I know that this has already been discussed on here some but all ...
1
vote
0answers
86 views

Storage solution for realtime time series analytics

I'm designing a system which allows user to analyze their data over time. It is like a IoT database which stores a lot of information from different devices from the user. I don't think that a normal ...
0
votes
2answers
41 views

Why am I getting error 35353 when enabling CDC on a table with a CCI?

I'm trying to enable Change Data Capture on a table with a clustered columnstore index, a unique non-clustered index, and a non-unique non-clustered index in SQL Server Standard 2019. The command ...
0
votes
0answers
45 views

MS SQL 2017: Generate estimate execution plan take more than 3 min

Sometimes generate Execution Plan (estimated) for simple query take ~3min Query: SELECT MAX(field) FROM table_name WHERE Org = x and PartKey = y The table is columnstore cluster index SQL Server ...
0
votes
0answers
435 views

Using clustered columnstore indexes in conjunction with non-clustered columnstore indexes

Table A has approximately 500 million records in it and is of the form similar to the following | ID | FirstName | LastName | MiddleName | ------------------------------------------ | 1 | John |...
0
votes
1answer
78 views

Foreign keys without any checking or index

I have a problem on SQL Server that led me to the question of whether it is possible to define a foreign key that is not enforced, not backed by an index, and does not need the referenced columns to ...
0
votes
0answers
450 views

Columnstore Index Scan Cardinality Estimates

In SQL Server 2012, I am seeing large cardinality estimate discrepancies for a columnstore index scan. It looks like statistics have been generated for the index, but I don't see any details in DBCC ...
0
votes
0answers
119 views

Is it possible to set Buffer pool extension on table having clustered Column Store index in SQL Server 2014?

I created Clustered Column Store index on a table. I want to improve memory performance using buffer pool. Is it possible to set buffer pool on sql server, a table having clustered column Store index ...