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.

Denny's SQL Secrets When Should You Create New SQL Server Indexes? Here's how to spot when new indexes are needed to improve performance. By Denny Cherry 04/11/2014 ...

Many SQL Server operations can often be made faster by taking advantage of effective clustered indexes. It should be understood that this combination of a non-clustered and clustered index on the same ...

Denny's SQL Secrets Are Too Many SQL Server Indexes Hurting Your Performance? The question leads to an even more important question: do your users care? By Denny Cherry 07/16/2014 ...