I was looking into this again recently when selecting drive type for a new server.
I've got to admit, though SATA has a reputation for having caught up better with SCSI, as a standard configuration SCSI still seems to offer better performance, both in terms of seek times but also in terms of harddrive longevity with SCSI drives apparently lasting longer than STAT before fault.
On a lower end server I'm sure SATA would be fine. But on a quadcore Intel with 4GB RAM, I had to go for SCSI.
