Question : I remember that I once had a missing index on a table and one query was taking ages. […]
Tag: merge
Merge replication throws PRIMARY KEY violation during the initialization of Subscriber
Question : I am using SQL Server 2014 SP1 to set up merge replication on Windows 2008. The databases (Publisher […]
Merging two backups form a postgresql database
Question : I have a kind of big postgresql database and two backup files (each uncompressed dump file ~56 mb) […]
Why does this MERGE statement cause the session to be killed?
Question : I have the below MERGE statement which is issued against the database: MERGE “MySchema”.”Point” AS t USING ( […]
It’s possible to skip duplicate keys (i.e. MERGE) in a BULK INSERT in MySQL?
Question : I have a INSERT…SELECT statement that I want to run several times from TABLE1 to TABLE2 as the […]
How do I update and insert specific set of rows to an existing table using Merge in SQL Server 2008 R2?
Question : I have a table in the database that I need to update based on the records being passed […]
moving a Partition of Partitioned Table to other File Group, SQL Server
Question : I created partitioned table on DateTime column. for last 6 month. I placed 3 oldest month on a […]
SQL Server – Identical query on near identical database takes 20 seconds on sql2012 but does not complete after 50+ hours on sql2014
Question : I have 2 databases that contain nearly identical data. The first has compatibility level 100 and is restored […]
Merging table records across TabName for each PersonID
Question : Consider the following table, CREATE TABLE temp ( [TabName] VARCHAR(255), [PersonID] VARCHAR(255), [FirstName] VARCHAR(255), [Gender] VARCHAR(255), [BenefitType] VARCHAR(255), […]
SQL Server Merge vs MySQL Insert On Duplicate Key performance comparison
Question : I’ve been searching a lot for this kind of comparison or some sort of performance balance. What I […]