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?
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
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?
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?
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)
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?
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?
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
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
Question : I want to convert a rowstore table to a columnstore table by creating a clustered columnstore index. There […]