17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

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_payne.jpg
    Gavin is a solution architect leading, designing and implementing data 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. He also holds certification from the Global IT Architect Association. His technical expertise focuses on Microsoft SQL Server data platforms and cloud infrastructures, primarily in the retail and services sectors.
    http://blog.gavinpayneuk.com
  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.