Have you had a chance to check out the resource governor in SQL Server 2008 yet? If not, you should take a look. The resource governor allows you to categorize a connection (at the time of login) into a workload group. That group exists as part of a resource...