SQL Server Columnstore Index Performance Benefits

If you have a data warehouse and you frequently run queries using aggregate functions like SUM, AVG, COUNT, etc, you need to investigate columnstore indexes. I am going to show you some performance benefits that come from using this new (8 years old now) index type.

Continue reading SQL Server Columnstore Index Performance Benefits