GilaMonster (7/3/2013)

---

If you are never modifying any of the columns that are in the index, then the index has no update overhead. It'll still add overhead to inserts and deletes, but only updates that change columns in the index key/include have to touch the index.

if you are changing the Clustering key at all with your updates, all nonclustered indexes will be affected as well