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.

Clustering the DB is the answer if you already have an existing MS SQL cluster. Otherwise, it's likely more trouble than it's worth, especially if you're looking at a virtual MSCS cluster.

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.