• As far as I understand, unless the index is filtered, all inserts/updates/deletes will affect all nonclustered indexes.

    Think in a row level, not just on a field level

    EDIT - I might be and probably am wrong about the updates though.