Getting started with the SQL MERGE statement

  • Comments posted to this topic are about the item Getting started with the SQL MERGE statement

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

  • Nice article!

    Before using MERGE in MS SQL Server, it would be good read this article as well. I'm not sure how many of the bugs mentioned there have been fixed. Since Microsoft Connect was deliberately broken, AFAIK we have no way of knowing

     

  • The bugs daveBoltman mentioned is what keep me away from merge. It has had such a bad press. Has it recently changed? I would love to love merge, but this makes it really hard.

  • You can avoid MERGE in some cases:

    https://www.sqlservercentral.com/articles/how-to-avoid-merge-in-sql-server

    R Glen Cooper

  • First off, thanks for the article.  Please continue to contribute and don't let my post discourage you.

    I dove head-first into this statement when it first came on the scene.  Spent many DAYS trying to tune it for a specific need and I'm pretty sure I uncovered every bug before they were listed widely on internet forums.  Similar to what a few others already posted, I've been burned by this statement too many times to even consider using it.  Way to easy to just use Insert/Update/Delete and move on.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply