Columnstore Technical Deep Dive

Dive deep into the world of columnstore technology in Microsoft SQL Server 2014 with this comprehensive technical session. Explore the revolutionary addition of updateable columnstore and its significant impact on query performance. Gain insights into columnstore internals, understand how it differs from row store, and learn about the metadata that exposes this new information. Discover trends in data warehousing, in-memory technologies, and the intricacies of columnstore index types, creation, and compression. Examine query processing techniques, including segment elimination and batch mode processing, and their effects on performance. Analyze the implementation of clustered columnstore index in SQL Server 2014, its TSQL commands, and its impressive performance in TPC-H benchmarks. Master the concepts of row groups, segments, and horizontal and vertical partitioning to optimize your database performance.