Data Transfer from Table B to Table A - Timeout Error

• monilps

  SSCommitted

  Points: 1686

  More actions

  November 14, 2012 at 9:11 am

  #270159

  Hi,

  I have two tables - Table A and Table B.

  Table A has around 1 billion rows and Table B has around 2 billions rows which might me already present in Table A. I need to move data to Table B if that row doesn't exists in Table A. I tried using simple NOT EXISTS statement but it gave error as timed out. I checked my timeout setting and is set to "0" -> which means unlimited time (Query Option).

  Please let me know if there is any alternate way.

  Thank you in advance !!!

• Igor Micev

  SSC-Dedicated

  Points: 33110

  More actions

  November 19, 2012 at 3:45 pm

  #1560557

  Hi,

  You could use MERGE statement in this case, but you have to create indexes on the joining columns. The following link can help you: http://technet.microsoft.com/en-us/library/cc879317.aspx

  Regards

  IgorMi

  Igor Micev,My blog: www.igormicev.com