dwilliscp (9/7/2012)
To write new data using three outer joins or to use one outer join, and get most of the data, then use three updates to load the other three columns?
Usually the 1st approach is faster.
If any of these 3 columns have variable length (say varchar) then your update statement will cause a lot of page splits and therefore fragmentation.