Niko Neugebauer

Niko Neugebauer

(0 comments, 189 posts)

This user hasn't shared any profile information

Home page: http://www.nikoport.com

Posts by Niko Neugebauer

TSQL Tuesday #93: 2 Job Interviews

I decided to join the T-SQL Tuesday blog series that Kendra Little is leading this month, on the topic that is called “Interviewing Patterns & Anti-Patterns” The Job I HAD to skip Please, take this first part in the context…

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…

Columnstore Indexes – part 108 (“Computed Columns”)

Continuation from the previous 107 parts, the whole series can be found at http://www.nikoport.com/columnstore/ As we are approaching the RTM (release to manufacturing) of the SQL Server 2017, I decided to focus on the implemented features in the upcoming release,…

Columnstore Indexes – part 107 (“Dictionaries Deeper Dive”)

Continuation from the previous 106 parts, the whole series can be found at http://www.nikoport.com/columnstore/. I would like to thank Sunil Agarwal (Program Manager) & Vassilis Papadimos (Software Engineer) for all their patience and explanations, helping me to get to the…

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 106 (“Memory Requirements for Rebuild & Reorganize”)

Continuation from the previous 105 parts, the whole series can be found at http://www.nikoport.com/columnstore/. One of the most important and recurring topics for any type of indices is their Building/Rebuilding/Reorganzing processes – after all we do load more data into…

Columnstore Indexes – part 105 (“Performance Counters”)

Continuation from the previous 104 parts, the whole series can be found at http://www.nikoport.com/columnstore/. For a very long time I was intending to write some of the unsung & almost hidden improvements of the SQL Server 2016 – the performance…

Resumable Online Index Rebuild

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 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 103 (“Partitioning 2016 vs Partitioning 2014”)

Continuation from the previous 94 parts, the whole series can be found at http://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…
Niko Neugebauer's RSS Feed
Go to Top