Currently, you can set the Max Degree of Parallelism at two levels. At the server/instance level and at the query level. We deployed an ISV application that the vendor insists that I set the Max Degree of Parallelism to 1 at the server level. They believe it will help their application run better. I told them no because the database is on my production server that is shared by other applications and those applications could benefit from parallelism. I could set up a separate instance or set up a separate server to host this application's database, but that is a lot of overheard, plus the cost of licenses for a separate server, for a small database used by the application.
So, that being said, it would be great if I could set the Max Degree of Parallelism at the database level. This would allow me to satisfy the ISV requirements and still have parallelism for the other databases that are hosted on the server.