title: How to process the data in the table, which is frequently inserted
body: <p>I have a table dbo.RawMessage, which allows anther system to frequently(insert 2 records per second) insert data.</p>
  
  <p>I need to process the data in the RawMessage, and put the processed data in dbo.ProcessedMessage.</p>
  
  <p>Because the processing logic is not very complected, so  my approach is add a insert trigger in the RawMessage table, but sometime I got deadlock.</p>
  
  <p>I am using SQL SERVER EXPRESS</p>
  
  <p>My questions:
  1.Is this a stuipid approach?
  2.If not, how to improve?
  3.If yes, please guide me the graceful way</p>