The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
0answers
65 views

What exactly can SQL Server 2014 execute in batch mode?

When a columnstore index is being used in a query SQL Server is able to use batch mode. Documentation is thin on what can run in batch mode and what can't. Please look at the following (motivating) ...
2
votes
0answers
279 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 ...
0
votes
0answers
16 views

Oracle In-Memory POPULATE_STATUS does not change to completed

I'm experimenting with the Oracle In-memory options for BI purposes, when I'm trying to populate one table to in-memory in the v$im_segments the POPULATE_STATUS does not change to completed, for other ...
0
votes
0answers
22 views

Greenplum database storage model for time series data

I have to deploy a greenplum database for analysis of time series data. I will have around 50 different time series (s1,s2,s3,...s50) and each series will have multiple pairs (time is 1 hour average ...