>Does SQL Server have the ability to do bulk inserts or updates like Oracle does?
Yes, but I am talking about single update.
For example, a table has 4 millions records with 145 indexes, where some of them are compound. The insert would take about 0.9 second. This is the part I would be interested to know if optimization can be done.