Method to update LOB data with minimal log
Use the .WRITE (expression, @Offset,@Length) clause to perform a partial or full update of varchar(max), nvarchar(max), and varbinary(max) data types. For example, a partial update of
Tag: update
How update works in transactional replication?
In a post about how update works I showed what happened when run an update with the same values. SQL Server
