SQL Server 2014 xVelocity Enhancement: Updateable Columnstore Indexes

  • November 7, 2013 · 6:30 PM
  • Microsoft Office

Speaker Pat Sheehan, Data Platform Architect, Microsoft

Pat will offer an overview of the xVelocity engine enhancements for columnar data and review columnstore –v- rowstore.  You'll learn how and when to apply columnstore indexes, and see the radical improvement that columnstore can provide. Pat will demo a Data Warehouse system being optimized using Columnstore Indexing.

You'll learn:

• Where columnstore indexes are best suited, and, just as importantly, scenarios where they are not suited

• How and why columnstore may provide orders of magnitude performance increase for your DW systems

• How to create columnstore indexes

And according to Pat, the #1 reason to create columnstore indexes is...."All the cool kids are doing it"!

Pat Sheehan recently joined the Microsoft Silicon Valley Technology Center (SVC MTC) as Data Platform Architect. Prior to that, he was with Microsoft Consulting Services (MCS) as an engineer, architect, and enterprise strategist, specializing in SQL Server, Business Intelligence, and Enterprise/Solutions Architecture.




Join or login to comment.

Our Sponsors

People in this
Meetup are also in:

Imagine having a community behind you

Get started Learn more
Henry

I decided to start Reno Motorcycle Riders Group because I wanted to be part of a group of people who enjoyed my passion... I was excited and nervous. Our group has grown by leaps and bounds. I never thought it would be this big.

Henry, started Reno Motorcycle Riders

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy