Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: columnstore

Does Batch Mode only apply to Agg Functions on ColumnStore Index

By adminPosted on September 23, 2023

Question : Azure SQL Database – Standard Edition (S3 Service Tier) Why does Batch Mode only come into effect when […]

Create failed for Index ‘ClusteredColumnStoreIndex’. Timeout expired

By adminPosted on September 20, 2023

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?

By adminPosted on September 10, 2023

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

By adminPosted on August 23, 2023

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?

By adminPosted on August 20, 2023

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

By adminPosted on August 17, 2023

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)?

By adminPosted on August 16, 2023

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

By adminPosted on July 24, 2023

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

By adminPosted on July 23, 2023

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]

By adminPosted on June 21, 2023

Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]

  • 1
  • 2
  • 3
  • …
  • 11

Recent Posts

  • connect SQL server file (mdf) with R tool [closed]
  • Database running out of space
  • Postgres backup PITR strategies [closed]
  • Installing SQL Server 2014 Enterprise in Windows 7 Ultimate 64 Bit Incompatibility Error
  • CPU Time Slower in SQL Server 2014 than in SQL Server 2008 R2 [closed]
  • Postgres doesn’t use expression index for group by
  • Suggestions for type of DB to use (Elasticsearch vs MongoDB vs Hadoop)
  • Creating Indexes to optimize query
  • Does joining to the same table twice have a predictable performance impact
  • Can we prevent table from update directly but allow update using trigger from another table?
  • Querying ‘random’ Oracle data via openquery in SQL Server returning the same data for multiple runs
  • The implications of lack on indexes on supporting a large production database
  • How to limit work_mem on PostgreSQL
  • Select max(pk) instead of sequence.nextval
  • Query detailing differences between rows for a large amount of data
  • How to combine `delete` and `insert` operations in one statement?
  • Slow SQL Server database on a specific server [duplicate]
  • How to model the relationship between these three tables
  • Error when migrating MySQL 8 to SQL Server 2019
  • multiple MYSQL full text indexing for innodb and memory + disk efficiency

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding