Loading
Topic
Queuing Pattern
1 post about Queuing Pattern by 1 contributor.
Know Queuing Pattern? Share what you know with developers who are learning it.
+ Follow Queuing PatternBe the first to follow this
- Articles
- 1
- Contributors
- 1
Articles about Queuing Pattern
- Article · SQL Server
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.
