T-SQL Script: Check index usage (find unused indexes)

SELECT 
    OBJECT_NAME(i.object_id) AS TableName,
    i.name AS IndexName,
    user_seeks,
    user_scans,
    user_lookups,
    user_updates
FROM sys.dm_db_index_usage_stats s
RIGHT JOIN sys.indexes i 
    ON i.object_id = s.object_id 
    AND i.index_id = s.index_id
WHERE OBJECTPROPERTY(i.object_id, 'IsUserTable') = 1
AND i.index_id > 0
ORDER BY user_updates DESC;