Of course, what's missing in such examples of moire, are comparisons of the same scene shot from the same position with lenses of equal quality, using two cameras with the same pixel density, one of which has an AA filter and the other which doesn't. We will now be able to make such comparisons with the D800 and D800E.
Slobodan has provided an example of Moire from the 40D, and I also have examples of moire from the 40D, and examples from other cameras that include an AA filter.
When we see an extreme example of moire, such as that from the OP, it looks bad of course, but we may erroneously assume that in the same situation, using the same quality of lens at the same aperture, we would not get any moire at all with another camera which includes an AA filter.
What might be the case in all these extreme example of moire from cameras without an AA filter, is that most cameras of similar pixel density, which do have an AA filter, will also produce noticeable moire, just not quite as bad