How to (efficiently) update millions of records in a SQL table

You need to update one or more columns in a table with millions of records with data from another table, what's a good way of going this with low risk and in an optimized way? One of my favorite ways of dealing with millions of records in a table is processing inserts, deletes, or updates … Continue reading How to (efficiently) update millions of records in a SQL table