title: Why not make all database tables datarows-locked?
body: <p>What are the disadvantages of altering a database table from allpages-locked or datapages-locked to datarows-locked?</p>
  <p>A row lock locks only a single row on a page. That way the risk of deadlocks is reduced.
  But what are the disadvantagesof a datarows-locked table compared to an allpages-locked or datapages-locked table?</p>