title: SQL server limit resources for a stored procedure
body: <p>I have a stored procedure that takes up too much of server resources. I want to limit this query to only use no more than, say, 10% of the reosurces. I've heard of <a href="http://msdn.microsoft.com/en-us/library/bb933866.aspx" rel="nofollow">Resource governor</a>, but it is only available for enterprise and developer editions. I have a standard edition.
  Is there any other alternatives to this, except for buying a better version of sql server?</p>