title: SQL Server 2008 Standard limit resource use per user or database
body: <p>I need to limit the CPU time used by a single user on SQL Server 2008. Unfortunately this is for Standard Edition, so I can't use Resource Governor.</p>
  
  <p>This user is running data-heavy queries via an Access database linked to one of the databases.  This is causing high enough load on the server that other queries can timeout.</p>
  
  <p>Is there any way to limit CPU usage by user or database in SQL Server 2008 Standard Edition, which is transparent to the queries being run?  </p>
  
  <p>What about on the connection from Access?</p>