Azure SQL Devs’ Corner

Voices from the Azure SQL PM Team, focusing on development and developers

Optimize Azure SQL Upsert scenarios

Customers often need to move a dataset from a source system into a new destination, inserting rows that doesn't exist in a target table and update those that already exists. With this technique, we've been able to reduce the time needed to upsert a dataset of 2M rows against a target table with 30M rows from 20 hours to 20 minutes.