Question : Azure SQL Database – Standard Edition (S3 Service Tier) Why does Batch Mode only come into effect when […]
Tag: columnstore
Create failed for Index ‘ClusteredColumnStoreIndex’. Timeout expired
Question : I am creating Clustered Column Store Index in SQL Server 2014. I am getting error as “Timeout expired. […]
Is the eager spool operator useful for this delete from a clustered columnstore?
Question : I’m testing deleting data from a clustered columnstore index. I noticed that there is a large eager spool […]
Storing 5TB web server access log vs OLAP DB
Question : We have over 5TB compressed web server log in a HDFS and we often analyse using Hadoop. It […]
When are dimension tables still needed using clustered columnstore indexing?
Question : I am using MS SQL Server 2016 Clustered Columnstore Indexing (let’s call it CCI) in my reporting database. […]
Columnstore index and low selective columns
Question : I have a table with almost 1T rows. create table bigtable ( K1 int, K2 date, — PK […]
What is an efficient storage method to store Graph Data from GraphX (Spark)?
Question : I generate graph data using Spark’s GraphX library and I need an efficient way to store graph data. […]
Difference between Clustered Columnstore Index Table in Azure SQL and Table in Azure Data Warehouse
Question : What is the essential difference between a Clustered Columnstore Index table in Regular Azure SQL, and a table […]
Column store index for on premise Kimball Data Warehouses
Question : Are column store tables now the vendor default method for Kimball Data Warehouse tables with Dim and Facts […]
Record scan speed, column orientated databases and SSDs [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]