Is this all due to the high pixel count, or is it poor in-camera processing?
I recall reading somewhere that the D50 handles noise better than any other Nikon camera, and that the D200 doesn't handle noise nearly as well. Since both cameras use the same Sony sensor, maybe this is the type of noise that you're gonna get in warm-ish weather at ISO 800, 1600, etc?
Wish I could post a photo of a cityscape at night, but most of my shots at night have been on boats and not the sharpest due to the motion of the boat, or waves. Here's one I didn't take with a tripod, but it was resting on something.
"Brisbane"
ISO 800
focal length: 32 mm
Aperture: f/2.8
Shutter: 1/8 seconds
Lens: Sigma 24-70mm f/2.8
Camera: Nikon D50
Noise from my D50 tends to be worse if the scene is shot using a "warmer" WB setting. I used the "shade" WB setting because I really like it, but at ISO 1600, the noise is unbearable sometimes and I have to make the photo "cooler" to lessen the noise. It's still warmer than it should be if I don't make it as warm, but I'm better off just not using "shade" anymore at ISO 1600.
"Eagle Pier"
ISO 1600
focal length: 24 mm
Aperture f/2.8
Shutter: 1/13 seconds
Lens: Sigma 24-70 mm f/2.8
Camera: Nikon D50
I don't have a shot handy at night using ISO 1600 and without the "shade" WB on me.