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

Tag: columnstore

Adding COMPRESSION_DELAY to an existing COLUMNSTORE INDEX

By adminPosted on January 29, 2023

Question : When I create an COLUMNSTORE index I can specify COMPRESSION_DELAY = x [minutes] in the CREATE-Statement. It delays […]

Why does CCI creation on an empty table request a huge memory grant?

By adminPosted on January 2, 2023

Question : On a QA server with very low memory, I experienced error 8545 when creating clustered columnstore indexes on […]

Storing Live Timeseries Data in SQL Server Azure Database

By adminPosted on December 21, 2022

Question : I have an SQL Server Azure Database and am trying to store time-series data that I get from […]

Why can it take up to 30 seconds to create a simple CCI rowgroup?

By adminPosted on December 10, 2022

Question : I was working on a demo involving CCIs when I noticed that some of my inserts were taking […]

Does my table qualify for Clustered Columnstore index?

By adminPosted on December 5, 2022

Question : I have a large table with 30 columns in MSSQL 2014. The data will be inserted in bulks […]

MSSQL – How to support aggregate pushdown on indexed view with SUM(decimal)

By adminPosted on November 28, 2022

Question : I have an indexed view with non-clustered columnstore index, e.g. CREATE VIEW [dbo].[SalesAggregated] with schemabinding AS SELECT BusinessDate, […]

How to create column group in WiredTiger engine in mongodb 2.8?

By adminPosted on November 28, 2022

Question : MongoDB 2.8 supports WiredTiger strorage engine, and WiredTiger supports column grouping. How we can create a collection in […]

Do I still need to disable or drop column store index before insert and/or update on big tables?

By adminPosted on November 27, 2022

Question : As the title says, I thought that from MSSQL 2016 I don’t really have to drop or disable […]

Optimize BETWEEN Query in SQL Server Azure

By adminPosted on October 18, 2022

Question : I have a table that stores time-series (5-minute) data and am trying to run a query that has […]

Code creating clustered columnstore index while maintaining row order

By adminPosted on October 15, 2022

Question : I want to convert a rowstore table to a columnstore table by creating a clustered columnstore index. There […]

  • 1
  • 2
  • 3
  • …
  • 9

Recent Posts

  • Speed up INSERTs
  • Regularly updating table with huge amount of rows
  • How can I create a gapless sequence?
  • Unable to Query Very Large Table
  • Why should I create an ID column when I can use others as key fields? [duplicate]
  • Force NOW to return new timestamps without committing the transaction
  • MariaDB on Windows Server 2012 R2 – out of memory
  • How to easily convert a comma seperated list of ids into a table of rows
  • clusterdb stopped working for PostgreSQL database in Ubuntu 12.04 server
  • Slow MySQL query
  • Database design : hotel room and its detail
  • How to use GROUP BY in an efficient way without losing attributes? [closed]
  • Query execution time is random, need to identify the root cause
  • Returning data where all categories exactly match
  • Partitioning increases CPU usage in mariadb
  • How to script out push subscription creation at the subscriber?
  • Can a transitive join loop infinitely?
  • 2 similar queries in large sql server table – 1 takes too long
  • Select data from another database instance on the same server in sql server
  • Is it possible to get server roles and database roles in a same query/script?

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