Batch Mode

Columnstore Indexes – part 109 (“Trivial Plans in SQL Server 2017”)

Continuation from the previous 108 parts, the whole series can be found at http://www.nikoport.com/columnstore/. Do you remember one of the major problems in SQL Server 2014 using Columnstore Indexes ? It was the lack of the support for the Batch…

Precon at PASS Summit 2017 – Columnstore Indexes: Practical Solutions & Techniques

It is with an incredible joy and gratitude that I am able to share that I will be delivering a full-day precon (workshop) at PASS Summit 2017: Columnstore Indexes – Practical Solutions & Techniques on 31st of October 2017 in…

Columnstore Indexes – part 104 (“Batch Mode Adaptive Joins”)

Continuation from the previous 103 parts, the whole series can be found at http://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 98 (“Null Expressions & String Aggregates”)

Continuation from the previous 97 parts, the whole series can be found at http://www.nikoport.com/columnstore/. Continuing with the spirit of the previous blog post on the string data type limitations I decided to add a couple more items that are showing…

Columnstore Indexes – part 93 (“Batch Mode Adaptive Memory Grant Feedback”)

Continuation from the previous 92 parts, the whole series can be found at http://www.nikoport.com/columnstore/. Given that currently the Batch Execution Mode is an exclusive feature of the Columnstore Indexes, and that the new developments in the query optimisation area are…

Launching Columnstore.NET

I am so glad that the time has arrived to announce my next project – the Columnstore.NET! This site will incorporate all useful information on the Columnstore Indexes & Batch Execution Mode, including blog posts (from different sources), presentations, case…

CISL 1.4.0 is released

Another happy release of the CISL (Columnstore Indexes Script Library) is live – this time it is 1.4.0! This release is focusing on the addition of the Extended Events, so that a user of CISL can easily set up the…

Columnstore & Memory-Optimised Workshop in Redmond (10.31-11.02 2016)

I am so happy that I can finally announce the very first Columnstore & Memory-Optimised Tables Workshop in the USA: on the 31st of October 2016 the Columnstore & Memory-Optimised Workshop will take place in Redmond, Washington! This workshop will…

CISL 1.3.1 is released

I am happy to share that the newest release of the CISL (Columnstore Indexes Script Library) – 1.3.1 is live! Do not get confused by the small incremental of the build version – this release is something that anyone should…

Columnstore Indexes – part 86 (“New Trace Flags in SQL Server 2016”)

Continuation from the previous 85 parts, the whole series can be found at http://www.nikoport.com/columnstore/ With the release of SQL Server 2016, a great number of new functionalities with specific internal structures and own behaviours were created (Columnstore Indexes – part…
Go to Top