This is a good and comprehensive discussion of how to handle indexes as they related to update and delete operations for SQL Server:
http://www.windowsitpro.com/Article/ArticleID/25198/25198.html?Ad=1