CXPACKET Wait Type Another great way to know that it is time to add indexes to a SQL Server database is by looking at the specific wait types for the queries which are running longer than expected.

First introduced in SQL Server 2012, columnstore indexes can give you major performance gains -- provided you have the right workloads. Here's how columnstore indexes work and what types of data ...

(You can also use a query hint to force SQL Server to use the columnstore index). Columnstore index usage will show up in the query execution plan, just like any other type of index. Columnstore ...