Merging Data Using A Queuing Pattern

In my recent article Using Materialized Views Effectively, I offered a few ways to populate data stores that can be critical performance-improvers for your apps and BI environments that use SQL Server. I showed how we could incrementally improve the loading process for these specialized tables - starting from a simple TRUNCATE / INSERT, to a MERGE statement, to a MERGE filtered based on “since last load.” This article covers another method that I’ve been using in production situations, with good success.

source https://www.c-sharpcorner.com/article/merging-data-using-a-queuing-pattern/