title: Understanding the Commit process regarding the transaction Logs
body: <p>I have a query about transaction logs regarding sql server 2005-08. When is a transaction written to the transaction log. Is it written the the data file before its written to the log file or is it written to the log file first before its commited to the database. </p>
  
  <p>Thanks</p>