Blog Post

SQL 2014 ColumnStore Indexes

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:

[email-download download_id=”750″ contact_form_id=”739″]

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.

One thought on “SQL 2014 ColumnStore Indexes

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Posts