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

Non-clustered index corruption leads to incorrect reading of the SQL database query or multiple read operations on the same value. SQL database in suspect mode: SQL database suspect mode is a frequent ...