Home Forums SQL Server 2005 Administering remove rows from staging table that are duplicated before insert the data into the database normal tables RE: remove rows from staging table that are duplicated before insert the data into the database normal tables

  • I believe the pattern I have proposed will outperform the pattern you have proposed. My proposal only makes one pass at the data while yours makes multiple passes and multiple copies so much more write activity in particular.