In-Memory is the new buzzword of the modern age. It doesn’t matter on which database vendor you look at, everyone offers you In-Memory technologies. The same applies to SQL Server: In-Memory OLTP and ColumnStore Indexes. But what’s the idea behind these 2 new technologies in SQL Server? Does it make sense to use these technologies for your own SQL Server workloads? When does it make sense to use In-Memory OLTP, when does make it sense to use ColumnStore Indexes?
In this 6 hour long online training you will learn about:
- In-Memory OLTP
- Why In-Memory OLTP
- In-Memory OLTP Databases
- Hash and Range Indexes
- Native Compilation
- ColumnStore Indexes
- Overview
- ColumnStore Indexes in SQL Server 2012
- ColumnStore Indexes in SQL Server 2014
- ColumnStore Indexes in SQL Server 2016
- Performance Troubleshooting
