There is a lot to love about SQL 2008 and while I will be upgrading as much as possble to 2008 for the Policy Based Management functionality which will make my life so much better, I think my most favorite thing about 2008 is a small thing.  The ability to query multiple servers from Studio Manager.   When you manage a number of servers, looking up simple things can take a time.  For instance, everyday I want to know how many databases do I have on the beta servers so that I can plan for our hardware needs.  In previous versions, I would need to write a little app that would use linked servers to connect to each server and pull back this information and then aggregate myself.   Once you write this not a big deal, but it is a hassle and I would prefer to not to have to deal with linked servers whenever possible,  Now I simply query a server group and write a simple SELECT COUNT(*) from sysdatabases.    I do wish I order on the servername, but maybe in a future release.