ColumnStore Index: Microsoft SQL Server 2014 and Beyond
Play ColumnStore Index: Microsoft SQL Server 2014 and Beyond
The updateable clustered columnstore in SQL Server 2014 offers a leading solution for your data warehouse workload with order of magnitude better data compression and query performance over traditional btree-based schemas. This session describes columnstore index internals with deep insight into data compression methodology for achieving high query performance. Additionally, we offer a sneak preview of column store investments planned for SQL Server.