title: Priorities to queries in SQL Server
body: <p>Is there anyway I can give priorities to thread for different queries in SQL.
  I have multiple queries running on a table at same time(Some are important while some are not that important). Is there anyway that i can give priorities to these queries </p>
  
  <p>Suppose there are 10 users running queries parallely on the same database. It there anyway that 1 single user can get more priority(more threads) to his queries.</p>