Niko Neugebauer

Niko Neugebauer

(0 comments, 199 posts)

This user hasn't shared any profile information

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

Posts by Niko Neugebauer

Columnstore Indexes – part 118 (“SQL Server 2017 Editions Limitations”)

Continuation from the previous 117 parts, the whole series can be found at http://www.nikoport.com/columnstore/. As a logical continuation from the blog post Columnstore Indexes – part 91 (“SQL Server 2016 Standard Edition Limitations”), this blogpost will focus on the SQL…

Presentations & Blogging of 2017 in Review

And here comes the 5th time I am reviewing what happened on the presentation an blogging side of my life, this time focusing on the past year of 2017. Like in the previous years (2016, 2015, for example), I am…

Columnstore Indexes – part 117 (“Clustered vs Nonclustered”)

Continuation from the previous 116 parts, the whole series can be found at http://www.nikoport.com/columnstore/ An important issue I have faced already a couple of times in production servers was the usage of the Nonclustered Columnstore Indexes vs the usage of…

Columnstore Indexes – part 116 (“Partitioning Specifics”)

Continuation from the previous 115 parts, the whole series can be found at http://www.nikoport.com/columnstore/ After delaying for a couple of years (yes, strangely there is other priority in my life, besides this blog post series) – I am finally putting…

Columnstore Indexes – part 115 (“Bulk Load API and Pressure”)

Continuation from the previous 114 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blog post is dedicated to the Bulk Load API and the sudden changes that might take place and affect it during the loading process into…

Columnstore Indexes – part 114 (“Machine Learning Services”)

Continuation from the previous 113 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blogpost is focusing on the unsung (and at the moment undocumented) improvement that is connected to the Columnstore Indexes, the communication between SQL Server relational…

Columnstore Indexes – part 113 (“Row Groups Merging Limitations”)

Continuation from the previous 112 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blog post serves as the continuation of the original blog post on the Row Group Merge functionalities that I have described in Columnstore Indexes –…

Columnstore Indexes – part 112 (“Linked Servers”)

Continuation from the previous 111 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blogpost is focusing on the Server Object functionality of the SQL Server – the Linked Servers. Almost everybody knows that the Linked Servers are evil…

Columnstore Indexes – part 111 (“Row Group Elimination – Pain Points”)

Continuation from the previous 110 parts, the whole series can be found at http://www.nikoport.com/columnstore/. The topic of the Segment Elimination (aka Row Group Elimination) is something that I keep on blogging on through all the years, but given that Joe…

Columnstore Indexes – part 110 (“The best column for sorting Columnstore Index on”)

Continuation from the previous 109 parts, the whole series can be found at http://www.nikoport.com/columnstore/. In this blog post I wanted to share my thoughts & my script that I am using for picking the best column for achieving the best…
Niko Neugebauer's RSS Feed
Go to Top