I've been seriously ramping up on the SQL Server 2008 feature set over the past few weeks, and I'm noticing that there are a ton of new features in the database engine that not a lot of people are talking about. Everyone hears about the biggies - Resource Governor, new Date data types, Spatial...
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 pool. At the pool level, you can set minimums...