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

Non-clustered Columnstore Indexes are also getting some enhancements in SQL Server 2016. The most notable of these enhancements is the ability to be updated.

Non-clustered indexes can be numerous in SQL Server 2008 I remember from my Sybase days that SQL Server tables could support up to 255 indexes. One clustered index and 254 non-clustered indexes.

Missing Indexes Dynamic Management Views SQL Server includes a set of dynamic management views which tell you what indexes the SQL Server database engine thinks need to be added.