Can a non-clustered index be rebuilt online?
Non-clustered index usage guidelines in SQL
Monitoring and troubleshooting non-clustered index performance issues
Non-clustered index key order: ascending vs descending
When should you consider dropping a non-clustered index?