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.
Sorry, there are no downloads available for this session.
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.
The video is not available to view online.