The SQL MERGE statement can make your DML querying more efficient but you need to take care or you may get burned  Read more...

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

Read more...

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

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

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

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...

Generates the merge statement for a given table.  Read more...

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...

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

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