Continuation from the previous 74 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post focuses on one of the newest additions to SQL Server 2016, the feature that most probably has gained a universal appraisal since the…
Continuation from the previous 73 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Row Group merging & cleanup is a very long waited improvement that came out in SQL Server 2016. Once Microsoft has announced this functionality, everyone who…
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 71 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I have previously written on the Rowstore Operational Analytics, and now it is the time to dive into the InMemory Operational Analytics in SQL Server 2016…
Continuation from the previous 70 parts, the whole series can be found at https://www.nikoport.com/columnstore/. In the SQL Server world of data modification tracking, there are 2 very important features, which are called Change Data Capture (CDC) and Change Tracking (CT).…