Some basic principles: Select your indexes and sortable columns wisely, it can be the difference between hours and seconds runs Try to process your data in chunks, create a staging table where you do your transforms with smaller amounts of data, instead of transforming all the data at all times. Try to batch the changes […]