title: Lock Sequences In SQL Server
body: <p>Does anyone know of a resource that will tell me the sequence of locks that will be taken out on a table/page/row/index during a select/insert/update/delete in SQL Server 2005 AND how different table hints and isolation levels will impact the locks taken?</p>
  <p>I know I am asking a lot here, but surely this information must be documented somewhere?</p>
  <p>Thanks in advance.</p>