Realtime Analytics: OLAP & OLTP in the mix! [DBA]
BI/Analytics Practitioner, Database Developer, DBA
Since SQL Server 2016 it is possible to have an OLTP & OLAP workload together. This can be achieved using columnstore indexes.
We will start off with a brief history on how the columnstore indexes evolved in the different SQL Server versions. Then we will take a deepdive on how the columnstore works, explaining what a delta store is, how delete and update operations work, what batch mode processing is, what the different kind of segments are & how to maintain your columnstore indexes.
We will conclude by showing you how to combine OLTP & OLAP workload on a database as seen in the field. Showing you issues you might face & how to make it fit for your environment
Basic knowledge about SQL Server.