Non-clustered index and memory-optimized tables in SQL
Non-clustered index and filtered indexes in SQL Server
Non-clustered index and query performance in SQL Server
Non-clustered index and uniqueidentifier data type in SQL
Non-clustered index and index fragmentation in SQL Server