title: Priority of a query in MS SQL
body: <p>Is there a way to tell MS SQL that a query is not too important and that it can (and should) take its time?</p>
  
  <p>Likewise is there a way to tell MS SQL that it should give higher priority to a query?</p>