Show 7 – In-Memory OLTP and Columnstore Indexes




SQL Server Radio show

Summary: <a href="http://traffic.libsyn.com/madeirasqlserverradio/SQLServerRadio_Show007.mp3" target="_blank">Download Episode (mp3)</a> On this in-depth show, we take a deep dive into the two biggest features of SQL Server 2014: In-Memory OLTP (aka Hektaon) and Clustered Columnstore Indexes. We talk about the data structures of the two features, how they differ from the traditional data structures, and why they allow such staggering performance boosts. We also talk about things you need to take into account and watch out for when working with them, and about the types of workloads that can benefit from them. Items mentioned in the show: * <a href="http://www.madeirasql.com/courses/course-catalog/sql-server-2014/" target="_blank">What's New in SQL Server 2014 Course</a> * <a href="http://sqldownunder.com/Podcasts/Shows/62" target="_blank">SQL Down Under Show 62 with Paul Larson</a>