Socket 939 is great, however it ended with the FX-60. Socket 940 are coming out really fast making socket 939 one of the most shortest lifespan of the AMD based motherboard. I guess it's because of the 65 nanometer CPU of Intel. So 940 are really coming out with some of the fastest CPU and not to mention the quad they have been talking about. There's nothing wrong with the 939 in fact it is now the mainstream amongst AMD users. However with the socket 940, it makes your system future proof. Im looking to changing to socket 940 in several months myself.
He's talking about s940 now (Opteron). It depends on what you need. Do you need a high bandwidth SCSI/RAID/SATA controller? Do you need over 4gb of memory? Is dual NICs a must have? Do you need Registered memory?
The apps you mentioned, are more cpu intensive than anything. In that regard, a single dualcore chip will be just as fast as dual single core chips of the same clockspeed. What you get with a dual socket board is the ability to run >2 cores, more than 4gb of memory as well as it being Registered. You also get more options as far as expansion goes. Dual socket boards use PCI-X which can operate at 33mhz/66mhz/100mhz/133mhz. Some boards also have x8 and x4 pci-e slots.
I used to run a dual Opteron setup, but when dualcore chips came around I ditched it for an x2 4400. A lot of people look at dualcore chips as some weird, crazy or even useless invention. Where as I look at it as having the cpu power of dual processors for a heck of a lot less money.