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 ...

When you use index views in the right situations, they can dramatically improve the performance of SQL Server queries. Tim Chapman explains why performance testing is the best way to tell if ...

Microsoft’s Bradley Ball dives into the inner workings of SQL Server indexing to help developers and DBAs speak the same ...