SQL Server 2017 / SQL Server 2019 January 6th, 2020 A simple use case for columnstore indexes In this tip, I show how and why a columnstore index can provide benefits to COUNT(*) queries.