Showing results for Optimization - Azure SQL Devs’ Corner

How to solve the common problem of "insert-if-not-exists" in a very elegant, clever and scalable way.

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.