SQL Server 2012 – Columnstore Indexes
If you have a large reporting data and have not explored the new Columnstore Indexes. Take some time to review what you are missing. Unlike regular database indexes (rowstore format) that index tables based on the data tied to a row. Columnstore indexes compress the data within a column to quickly index common fields such … [Read more…]