If you are using indexed views and MERGE, please read this!

Here is some information about an important MERGE “wrong results” bug, involving indexed views, that could be affecting the accuracy of your queries right now, and what options you have for working around the problem.

Stairway to T-SQL DML Level 12: Using the MERGE Statement

The final level of this stairway looks at the MERGE statement in detail, focusing on how to perform insert, update and delete logic using the MERGE statement.

Merge, Metadata and the Data Mart ETL

Here's a great method for managing ETL for data marts and small data warehouses with just T-SQL.

MERGE Statement Generator

Generates the merge statement for a given table.

MERGE with OUTPUT clause

A few days back I was presented with a theoretical challenge, and now I thought I would share my solution...

Using the MERGE Statement in SSIS Via a Stored Procedure

Step-by-step instructions how to build a stored procedure that dynamically constructs and executes a merge statement within SSIS.

Merge statement

Slowly changing dimensions using T-SQL MERGE

Of all the technical solutions to the problem of slowly changing dimensions, the T-SQL MERGE statement is one of the most elegant.

Merge error handling

Learn to use recursion to determine which row caused your merge statement to fail in this article.

The MERGE Statement in SQL Server 2008

When the SQL MERGE statement was introduced in SQL Server 2008, it allowed database programmers to replace reams of messy code with something quick, simple and maintainable. The MERGE syntax just takes a bit of explaining, and Rob Sheldon is, as always, on hand to explain with plenty of examples.