Non-clustered index and table locking in SQL Server
Non-clustered index and hash indexes in SQL
Non-clustered index and index visibility in SQL Server
Non-clustered index and table design considerations in SQL
Non-clustered index and index rebuild in SQL Server