There is allready a very popular MMO that uses MS SQL Server for it's data, EVE Online Smiley

They just tune it really well, and running IO from a RamSan system kinda helps I think Wink