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

SQL Server 2014 CTP1 introduced hash indexes for memory-optimized tables. Hash indexes are very efficient for point lookups, when you know exactly the value you are looking for. However, they do not ...

New for SQL Server 2016 is the ability to place a Columnstore Index on an In-Memory Table.

Columnstore indexes are available in CTP 3 of SQL Server Code Name “Denali.” You can create a columnstore index on your table by using a slight variation on existing syntax for creating indexes.

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

I wanted to get some suggestions for scheduled maintenace on a SQL Server 2000 box that is hosting a relatively small database (<=13GB). I already have a weekly integrity check that reorganizes ...