Chapter 6: New Features in SQL Server Release 11.0
Update
changes
Update strategies for SQL Server have improved. More updates
are now made in
place or directly, with fewer writes to the transaction log. See
the Performance and Tuning Guide for more information
on performance and update operations.