title: Best way to speed up MS SQL server
body: <p>I was wondering if anyone has some general sys admin questions on how best to setup MS SQL server for speed. I have placed the log files on a different drive with its own controller and moved the indexes to their drive but on the same controller as the main data files.</p>
  
  <p>What other way can a system admin setup MS SQL server to speed up disk access, query times?</p>