Niko Neugebauer continues a series on columnstore:
In the Columnstore Indexes space, there is a long-standing “tradition” in Microsoft to ignore the needs of the customers for data replication. It has started with with the original SQL Server 2012 release not supporting any data manipulation operations besides Partition switching. Since then it has been improved from version to version up until SQL Server 2016 where Nonclustered Columnstore Indexes has received a support for the Transactional Replication, and voila – that’s where it has stopped!
Read on for the frustration involved in moving around columnstore data.
anyone else having trouble loading Niko’s website?
That’s odd. I just tried with my wifi connection and on my mobile phone (over cellular) and both worked.