It shoots 1080p at 24 or 25 or 30 fps. It is unique in that it sends an uncompressed video signal through the HDMI port providing a live 4:2:2 HD stream at full 1080p resolution to an outboard recorder, as opposed to the 4:2:0 files it records on CF and SD cards.
Several TV series' are shot using a DSLR. The show "House" is shot completely with a DSLR. The producer claims it allows them to achieve shots with very low depth of field that is not allowed in standard movie cameras. So it appears that using a DSLR like the D800 makes a lot of sense.
On the contrary, if you are serious about video especially cinematographic video, then you will be considering the D800. To get the same quality from a regular video camera as what the D800 provides you'd be looking to spend $10-40k. It is that good.
Thanks for all the input....Basically i want to shoot in low lighting. I want to shoot close ups of people getting their hair cut so something with great detail.