Setting query priority
487405May 12 2006 — edited May 16 2006I would like to know if there's any way I can set some priorities for some queries or procedures. Basically there are certain queries that need to be executed, but lower priority. They need to be run or run periodically, but if other user queries are initiated, I want this is execute and give the result set rather than trying to finish both and sharing CPU cycles and memory.