title: SQL Transaction connected with WAITFOR DELAY
body: <p>I was looking through some posts but I couldn’t find similar case that could explain me if this solution is safe. I want to execute many <code>UPDATE</code> queries at once but due to server performance issues, I can run only limited number of queries at once. The solution seems to be easy by using <code>WAITFOR DELAY '00:00:05'</code> between queries, and execute everything at once.
  My transaction is going to look like this:</p>
  
  <pre><code>Begin tran 
  
  UPDATE Queries
  
  WAITFOR DELAY '00:00:05'
  
  UPDATE Queries
  
  WAITFOR DELAY '00:00:05'
  
  etc.
  </code></pre>
  
  <p>After manual verification how many rows are affected, I execute <code>commit tran</code>. Are all the queries updating at once when <code>commit tran</code> is executed causing performance issue? Is <code>commit tran</code> safe for use in my case? </p>