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.

What Is Non-Clustered Index In Sql Server With Example? In a non-clustered index (or b-tree index), the order of the rows is not the same as how the data actually appears. Rather, it is sorted based ...

If there are Key Lookup operators which are shown when looking at the execution plans, this tells you that index changes are needed to the non-clustered index which is being used by the query.

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.

In SQL Server 2017, ... To share an example, at one client, we had a scenario where tables that had clustered columnstore indexes and additional non-clustered (b-tree) ...

SQL Server 2012 includes a lot of new and exciting features. One feature that has caught the imagination of many in the user community is the high-performance feature called Columnstore Indexes.