I have been fascinated with another new feature of the upcoming SQL Server release and so I decided to blog about it. The new version of SQL Server (2017) introduces a very exciting feature for the DBA’s – the Resumable…
Columnstore Indexes – part 104 (“Batch Mode Adaptive Joins”)
Continuation from the previous 103 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post is a logical continuation of the blog post that I have published in December 2016 – Columnstore Indexes – part 93 (“Batch Mode…
Columnstore Indexes – part 103 (“Partitioning 2016 vs Partitioning 2014”)
Continuation from the previous 94 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I have been wanting to write on this topic for quite some time, but with all the exciting themes that I have on my todo list…
Columnstore Indexes – part 102 (“CCI with Secondary Rowstore Indexes on SQL 2014”)
Continuation from the previous 101 parts, the whole series can be found at https://www.nikoport.com/columnstore/. In SQL Server 2014 we have received a possibility to update the Columnstore Index directly with an addition of the Clustered Columnstore Index. This addition had…
Tuga IT 2017 Tickets are on sale
I am glad to announce thatTuga IT 2017 Tickets are finally on sale! Wait a second, you might think – on sale? How on earth and why in this galaxy (TM) are we asking for the money? What are we…