title: Using ROWLOCK in an INSERT statement (SQL Server)
body: <p>Would it be wise to use ROWLOCK on an insert statement that is copying large amounts of data and inserting it into the same table?</p>
  
  <p>Ex)</p>
  
  <pre><code>INSERT INTO TABLE with (rowlock) (id, name) 
     SELECT newid, name 
     FROM TABLE with (nolock) 
     WHERE id = 1
  </code></pre>
  
  <p>Does anybody have recommendations on how to improve this statement, as I see when SQL Server gets busy it will end in Timeout Query returned for SQL Server.</p>