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

Read more...

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

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

This article discusses about 'Partitioning'. In this detailed article, a particular emphasis is placed on the implementation of Partitioning in SQL Server.  Read more...

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.  Read more...

Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL.   Read more...

Read more...

Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL.   Read more...

This article discusses about 'Partitioning'. In this detailed article, a particular emphasis is placed on the implementation of Partitioning in SQL Server.  Read more...

This article by new author Glen Schwickerath uses dynamic SQL and SQL Server 2008's MERGE statement to create a useful stored procedure tool for synchronizing tables.  Read more...

This article about MERGE DML Statement in SQL SERVER 2008 and how to implements it and several examples   Read more...