Only the best lenses will be able to deliver good detail resolution, so using top quality lenses is mandatory.
I have to say that the Nikkor Af-s 24-70 f:2.8 never really convinced me on the D700 (soft corners - focus shift) but it seems to perform a lot better on the D800e but i'll have to use it more before i can come to a "real world usage" conclusion, two lenses that have really convinced me so far are the Nikkor Af-85mm f:1.4 G and the ever amazing Nikkor 14-24 f:2.8.
The Af-s 70-200 Vrii that performed very well on the D700 seems to be able to justly keep up with the demands of the D800e, if you don't need a zoom in this range i would certainly recommend switching to primes like the 85 f:1.8G or f:1.4G, i don't own one but i wonder how the 200mm f:2 would perform on this body...
About Moiré = not really an issue until now and not much worse than the regular D800 from what i've seen
Obvious question = Will a client see the difference between a 800px downscaled photo from the D700 or the D800e? No probably not, neither will he see you had to crop to 25% of the original and still have about 10Mpix files, that's at your advantage, so is sharpness and the really comfortable dynamic range a low ISO
Enough of the technical mambo jambo, time for some real life results i would say:
This is a "landscape crop" downscaled to it's websize:
>click here for 20MB of detail<
But if you don't feel like going for a walk on my Flickr stream here is a crop!
I had to downscale it to 75% to be 800px wide.. just a tiny amount of wtf goes around when looking at these files i can tell you!
But Mike wouldn't be Mike if he didn't have a model to shoot ;-)
Model is Julie Ghoos (She got a pretty score at the latest Miss Belgium contest. )
MUA / hair : Sophie Adam.
All was shot with the Nikon D800e + Af85mm 1,4G and Af50 1,4D
Details, details, details ...
This was a soft-focus technique to show the difference between a "normal" picture and the less contrasty one, feels a lot like a David Hamilton and that was the purpose because i was going to need some similar effect for my next shoot