Assuming you're a Sharepoint Hosting Service (The forum you posted in...) the answer is yes, plenty of advantages. Though really they are the same advantages of any hosting service using SQL2008. Same goes for Windows 2008 and IIS7, many advantages for hosters exist on this platform. Check Microsoft's hosting resources for guidelines on optimizing these.
Jeff