Deadlock when trying to update a table while Selecting

• Spork

  SSC-Addicted

  Points: 460

  More actions

  May 18, 2015 at 2:21 pm

  #151418

  I have a scenario where a job runs and performs the following action:

  Truncate table B.

  Insert into table B by selecting * from table A.

  Table B is then moved to a reporting database.

  This job runs for several minutes.

  At the same time the job is running, users are attempting to update Table A.

  They are receiving deadlocks because of the select statement.

  Any suggestions on the best option to prevent this issue?

  Thanks.