How to check if a table has a non-clustered index in SQL
Index statistics and query optimization for non-clustered indexes
Index maintenance for non-clustered indexes in SQL
Can a non-clustered index be used for full-text searching?
What is the difference between a non-clustered index and a filtered index?