Lowell (6/29/2015)
the funny thing is, that NC index gets used a lot when i look at the index stats
Yes, it will. Doesn't mean it's useful.
If you create 5 identical indexes on a table (index that will be used by the queries), wait a while then check index usage stats, all 5 will have been used.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability