SQLServerCentral.com Articles tagged MERGE

A Hazard of Using the SQL Merge Statement

Wed, 03 Apr 2013 06:00:00 UT

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

Using the SQL Server MERGE Statement to Process Type 2 Slowly Changing Dimensions

Fri, 08 Mar 2013 07:00:00 UT

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.

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

Thu, 14 Feb 2013 07:00:00 UT

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

Wed, 16 Jan 2013 07:00:00 UT

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.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Merge, Metadata and the Data Mart ETL

Thu, 27 Dec 2012 07:00:00 UT

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

Using the MERGE Statement in SSIS Via a Stored Procedure

Mon, 23 Jan 2012 07:00:00 UT

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

Slowly changing dimensions using T-SQL MERGE

Mon, 20 Jun 2011 06:00:00 UT

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

Tue, 02 Nov 2010 06:00:00 UT

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

Partitioning in SQL Server 2008

Fri, 01 Oct 2010 06:00:00 UT

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

The MERGE Statement in SQL Server 2008

Fri, 17 Sep 2010 06:00:00 UT

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.

Partitioning in SQL Server 2008

Fri, 01 Oct 2010 06:00:00 UT

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

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

Dynamic SQL Merge

Tue, 07 Apr 2009 06:00:00 UT

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.

Understanding the MERGE DML Statement in SQL Server 2008

Mon, 08 Dec 2008 07:00:00 UT

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