Here are the main
facts from the catalog including some comparisons to the fixed focal Sigma 300mm f/4.0:
Size: 92x224mm = 3cm longer than the 300mm fixed focal
Weight: 1455g w/o caps and collar but including lens-shade (115g) = quite heavy (250g more than the fixed focal)
Optics: some 16 elements in 14 groups = that's much more than a fixed focal has, but for a zoom it sounds quite reasonable
Closest focus distance/max.magnification: 1.8m / 1:5
Filter-thread: 82mm = expensive
No
IS = very bad
AF: built in focus motor/HSM, so does work on D40/x/D60-bodies

manual-focus override by turning the focus-ring
Covers
full frame/FX or smaller = normal
Comes with a nice looking
lens-bag
Price: around 550€ used / 1000€ new = not dirt-cheap
The front- and rear
lens-cap are cr*p (as usual with a Sigma lens)

It might be that a new copy has the new pincer-type front lens-cap
Distance information is relayed to the camera, so the Nikon body can do all the advanced exposure-related stuff with this lens
Aperture ring = yes, just like a Nikon D-lens, moves in 1 stops up to f/32
Supplied
lens-shade 
reverse mountable for carrying
Tripod-collar can be removed without dismounting the lens

, easy to turn camera to portrait-mode
Alternatives:
- The
Nikon AF-S VR 70-300mm 4.5-5.6G IF-ED (see Gordon's
review): again a very good choice including VRII. And a pretty reasonable investment. But you loose one stop at the long end plus some IQ in the corners (might get worse with FX-body). Cheaper than the Sigma.
- The
Nikon AF VR 80-400mm 4.5-5.6D ED: Nice lens (see my review
here) but a bit long in the teeth: no AF-S, no VRII, antique AF/MF switching not the best at 400mm f/5.6. More expensive than the Sigma.
- Unless you buy a Sigma (with OS) or Tokina (w/o OS/IS/VR) variant of the 80-400mm. But the
Tokina AT-XD 80-400mm 4.5-5.6 is not recommended (see
here).
But all those alternatives lack the
constant f/4.0 aperture 