Home Forums SQL Server 2005 SQL Server 2005 Integration Services History data Comparision and then Update flag on target table. RE: History data Comparision and then Update flag on target table.

  • July 17, 2013 at 2:44 am

    #1633144

    Over the period the no of rows can increase more than 500000 , whether LEFT outer join will increase the performance or any other option are available?

    Is it Partition of table will work out ? Please advice.