Our experience with nonclustered columnstore indexes
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.
- Capitol Area Central Texas Users of SQL Server 86 Recordings
- MS SQL 20 Recordings