Continuation from the previous 119 parts, the whole series can be found at https://www.nikoport.com/columnstore/. A couple of days ago at the SQLKonferenz, during my full-day precon I have recieved a question that I could not answer for sure, because I…
This post was originally written and almost finished on the 10th of July 2012 and 5.5 years later, I decided that I rather publish it then rework further or keep on the ice (yeah, I have dozens of drafts –…
Continuation from the previous 118 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This is a rather simple blog post that is dedicated to the theme of the In-Memory Columnstore Indexes location. This has been a constant topic of…
Recently I have made some very interesting discoveries about Hekaton (aka In-Memory OLTP) that I felt absolutely necessary to share with the world. I assume that the most people already know about this specifics, but discovering these details has helped…
Continuation from the previous 117 parts, the whole series can be found at https://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…