Manage Data Over Time with SQL Server MERGE Statement
Once data is in a table it needs to be maintained....
2023-02-15
Once data is in a table it needs to be maintained....
2023-02-15
This article is focused on beginners who have already started writing SQL queries and are now diving deep towards more data processing and complex queries in SQL. When we talk about data processing, an important concept that comes to our mind is performing ETL workloads to a data warehouse. ETL is a very complex topic […]
2021-01-26
4,974 reads
In this tip we look at how to use MERGE compared to running separate INSERT and UPDATE statements.
2018-09-26
3,483 reads
The term UPSERT has been coined to refer to an operation that inserts rows into a table if they don’t exist, otherwise they are updated. To perform the UPSERT operation Microsoft introduced the MERGE statement. Not only does the MERGE statement support the UPSERT concept, but it also supports deleting records. Greg Larsen discusses how to use the MERGE statement to UPDATE, INSERT and DELETE records from a target table.
2014-12-22
13,060 reads
A script to create MERGE statements with data for specific tables.
2015-09-03 (first published: 2014-05-19)
5,248 reads
The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?
2017-02-03 (first published: 2013-10-28)
170,981 reads
The SQL MERGE statement can make your DML querying more efficient but you need to take care or you may get burned
2013-04-03
24,783 reads
The MERGE statement is powerful and multifunctional, yet it can be hard to master. SOmetimes the MERGE statement that just doesn't do what it's needed to do, like process a Type 2 slowly-changing dimension. Check out this tip to learn more.
2013-03-08
3,847 reads
2013-02-14
2,282 reads
2012-06-20 (first published: 2012-05-30)
8,807 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers