Continuation from the previous 77 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I have decided to spend some time exploring the opportunities that Columnstore Indexes offer in the relation of the temporary objects. Temporary objects represent a very…
To support Microsoft with the upcoming release of the SQL Server 2016, OH22 have decided to open another public 2-days deep dive workshop on Columnstore Indexes. This public workshop will take place in Cologne on 10th & 11th of May…
Continuation from the previous 73 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Row Group merging & cleanup is a very long waited improvement that came out in SQL Server 2016. Once Microsoft has announced this functionality, everyone who…
Continuation from the previous 71 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I have previously written on the Rowstore Operational Analytics, and now it is the time to dive into the InMemory Operational Analytics in SQL Server 2016…
It is official – since a couple of weeks I have become a co-leader of one of the newest Virtual Chapters of PASS – In-Memory Virtual Chapter. What is In-Memory? In-Memory describes a set of technologies which are intended to…