Non-clustered index and query hints in SQL
Non-clustered index and foreign keys in SQL
How to find duplicate non-clustered indexes in a SQL database
Non-clustered index and index seek vs index scan in SQL
How does locking work with non-clustered indexes in SQL?