nadersam (3/27/2013)
I am asking that because i have a big table with a column included in many indexes and i am afraid that could have an impact on performance when executing update statements on that included column.
Have an effect, yes. Have a severe one, you need to test to see. Unless you're doing several updates in a row it probably won't be worth disabling all the indexes and rebuilding them after as the rebuild itself will take quite some time, plus you'll have the log impacts for all those rebuilds. Test though, see which is faster overall.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability