>>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.
Michel, it's quite unusual to need that many indexes. 4 million rows is not a small table but it's not astronomically large either.
How much memory is on your server, and what kind of processor/server architecture do you have?
Are you using SQL 2014 Enterprise? If so, the in-memory optimized table capability (known as Hekaton) "might" be able to help you out, though it would likely require some changes to stored procedures.