What's the best way, so locks can be avoided and other problems, a table with joins to other ones?
I read that using alias on the table being updated can cause locks and I see o lot of those...
UPDATE t SET t.c0 = j.c0, t.c1 = j.c1 FROM tableToUpdate t INNER JOIN joinTable j ON t.Id = p.IdFromT
-- vs --
UPDATE tableToUpdate SET tableToUpdate.c0 = j.c0, tableToUpdate.c1 = j.c1 FROM joinTable j WHERE tableToUpdate .Id = p.IdFromT
If you need to work better, try working less...