Cognitive Information

SQL 2014 ColumnStore Indexes

2014-06-08TulsaSQLRecently I was invited to speak at Oklahoma City SQL User Group and Tulsa SQL User Groups about the advancements available in SQL 2014 with Columnstore Indexes.

ColumnStore indexes were first introduced as xVelocity with SQL 2012 as a way to improve query performance against large data sets by grouping and storing columns of data instead of rows.  With SQL 2014, those ColumnStore indexes become update-able.   In this session, we review the difference in ColumnStore indexes, implementing ColumnStore indexes Clustered and Non-Clustered and monitor performance.

Allen is a Microsoft Certified Technology Specialist with certification in Business Intelligence Development and Maintenance. His IT specialties include database administration, business intelligence and medical imaging services.  He has designed and developed business solutions with the IBM Cognos and Microsoft SQL Server Business Intelligence platforms since 1999.

Subscribe to Download Presentation and Sample Files:

Your Name (required)

Your Email (required)

Select areas of interest

Check here if you accept the terms below.

Privacy Policy:  I will never sell or share your data.  When you sign up, I’ll send you a note when there is a new blog article about BI.  Unsubscribe any time.

Tags: , ,

One Comment to "SQL 2014 ColumnStore Indexes"

  1. […] August 23 – SQL Saturday 309 in Oklahoma City, speaking about Business Intelligence Basics and SQL 2014 Columnstore Indexes […]

Business Intelligence & Data Warehouse Consulting

%d bloggers like this: