Hekaton

Columnstore Indexes – part 82 (“Extended Events in SQL Server 2016”)

Columnstore Indexes – part 82 (“Extended Events in SQL Server 2016”)

Continuation from the previous 81 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Previously, I have blogged about about the Extended Events in SQL Server 2014 3 times: Columnstore Indexes – part 44 (“Monitoring with Extended Events”) served as…

Columnstore Indexes – part 74 (“Row Group Merging & Cleanup, SQL Server 2016 edition”)

Columnstore Indexes – part 74 (“Row Group Merging & Cleanup, SQL Server 2016 edition”)

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…

Columnstore Indexes – part 72 (“InMemory Operational Analytics”)

Columnstore Indexes – part 72 (“InMemory Operational Analytics”)

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…

Columnstore Indexes – part 64 (“T-SQL Improvements in SQL Server 2016”)

Columnstore Indexes – part 64 (“T-SQL Improvements in SQL Server 2016”)

Continuation from the previous 63 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I have decided to write a rather small blogpost, highlighting the T-SQL improvements already available in SQL Server 2016. The reason behind this blogpost is because…