title: Table locked during inserts... website unusable (sql server 2008)
body: <p>I have a background process that is constantly inserting into a table in real-time. It could be thousands of inserts an hour (with a few updates). This same table is used by the web application to get some data needed to display to the user. </p>
  
  <p>Currently whenever the background process runs its inserts/updates, the web app seems blocked and cannot access the database. </p>
  
  <p>I'm wondering what a good solution could be. Should I create another table where I insert into and than copy the table over to another table that is read only? Is there another method?</p>
  
  <p>Any help and suggestions is greatly appreciated!</p>