Our experience with nonclustered columnstore indexes

Speaker:

Yell McGuyer

Abstract:

We upgraded to SQL 2016 in part to take advantage of the updateable nonclustered columnstore indexes for our web based Credit Risk product for D&B. I will show you the before and after for our product as well as some general exercises using columnstore in a BI over OLTP environment.