Accelerating the data warehouse with columnstore indexes

xVelocity columnstore indexes, new in SQL Server 2012, were not just designed to make data warehouses run slightly faster, but massively faster.  To make this possible, a completely new approach to index storage and utilisation has been implemented by Microsoft in the SQL Server engine; something that must now also be implemented by data warehouse developers and DBAs.  With a balance of guidance and demos, this session will look at the benefits and restrictions of columnstore indexes, how they are implemented within SQL Server, and how you can use them.
Presented by Gavin Payne at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO

    Gavin is a solution architect leading, designing and implementing information platform and data centre transformations. He has a track record of delivering projects that provide new functionality, consolidation, and standardisation. He also provides guidance in the broader areas of enterprise IT landscapes and operational best practices. He is also one of 25 Microsoft Certified Architects for SQL Server in the world and a Microsoft Certified Master, and holds architect certification from the Global IT Architect Association, IASA. His technical expertise focuses on Microsoft SQL Server data platforms and cloud infrastructures, primarily in the retail and services sectors.

  • Video
    The video is not available to view online.