Continuation from the previous 72 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Since the very first version of SQL Server the maximum size for the Delta-Stores as well as the compressed Row Groups was limited to 1048567 Rows.…
Continuation from the previous 69 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post is the continuation from the previous one, where I have described the Operational Analytics for Rowstore. I have tried to create a filtered…
Continuation from the previous 68 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blogpost is dedicated to one of the key improvements in Columnstore Indexes in SQL Server 2016 – the Operational Analytics. This blog post is focused…
A couple of days ago, during the great SQL Unplugged live show, I have asked a couple of questions the leadership trio consisting of Shawn Bice, Nigel Ellis, and Rohan Kumar and was lucky enough to have them answered. The…
On 22 of January 2015, Microsoft Portugal is organising a new IT Pro Airlift 2015 – – Microsoft Data Platform event. This event is targeted for those who are using or curious about Microsoft SQL Server, Azure and overall offerings…