Saturday Keynote: Inside SQL Server 2012’s ColumnStore Index

This talk will describe how the new ColumnStore index technology in SQL Server 2012 makes queries go faster.  It will cover details of the storage and execution model down to how this model interacts with modern CPUs to deliver significant performance benefits on Data Warehouse queries.
Presented by Conor Cunningham at SQLBits X
  • Downloads
  • SpeakerBIO
    Conor Cunningham is a Principal Software Architect at Microsoft on the SQL Server Query Processor Team.  He's worked on database technologies for Microsoft for over 10 years and is holds numerous patents related to Query Optimization and Query Processing.  Conor is the author of a number of peer-reviewed articles on query optimization techniques.  Recently, he authored a chapter for the book "Microsoft SQL Server 2008 Internals" on how the Query Optimizer works.  He publishes a blog called "Conor vs. SQL" (http://blogs.msdn.com/conor_cunningham_msft/default.aspx)  where he answers questions about databases.
    http://blogs.msdn.com/conor_cunningham_msft/default.aspx
  • Video