SQL Server 2016 adds key enhancements to improve the performance and flexibility of columnstore indexes. This enhances data warehousing scenarios and enables real-time operational analytics. The objective of this session is Rationale for using columnstore index for DW and at the same time showcase new enhancements to columnstore index in SQL AzureDB and SQL 2016.We will do a deep dive in columnstore index internals where we are going to talk about new Physical structure, Query Performance, Concurrency and High availability .
Codice:
DA325
Room:
Room 7