I think the most efficient way is to use inner join when updating value from another table:

Update Table1 Set Col1 = Table2.Col1, Col2 = Table2.Col2 ...

From Table1 Inner Join Table2...