I can't speak to the Sony but I do own the Sigma 100-300 f4 APO DG and Sony a900 body. I am a landscape shooter and always photograph with a heavy tripod, MLU, and a cable release (when it hasn't fallen off my camera as the cheap Osaka releases seem to like to do). I am very impresed with the Sigma's image quality. The best example I have is this panorama of 15 vertical images stitched together:
http://www.brettdeacon.com/photo.php?id=526&gallery=GrandTetons . It is tack sharp at 100% magnification.
At 100mm, center sharpness is actually equal to, or possibly slightly better, than my (amazing) Minolta 100 2.8 macro. Center sharpness is excellent at all focal lengths. The extreme corners are less sharp for closer subjects, but generally not in a noticeably annoying manner (e.g., not as much of a problem as with my Zeiss 24-70 2.8). Center sharpness is good wide open. Bokeh is very good. Properly focused images are as good at 100% magnification as those taken with the Zeiss 24-70 2.8 and Minolta 100 2.8 macro (my other two lenses, both of which are outstanding).
On the downside, I've run into fairly consistent problems with image softness due to camera shake. I always use a heavy carbon fiber tripod and the 2-second timer which includes mirror lock-up, and at least 1/3 of my photos with this lens are less than tack sharp due to vibration. My explanation is that this is a big and heavy lens, and even when tightened on the tripod as much as my strength will allow and when used with perfect technique, the slightest vibration will be evident in the results. I've noticed, for example, that it's not even worth trying to use this lens in 20+ mph winds. I haven't used very large, long lenses before and can't comment on whether this phenomenon is to be expected with other lenses the size of the Sigma 100-300. I should note that my technique and standards are specific to those of a highly perfectionistic landscape photographer used to using a 4x5 camera. Those who might be using handholding this lens may have different needs and results. I hope this is helpful.