Most SATA hard drives sold now are AHCI compatible. Back in the early days of SATA (SATA I, 1.5 Gbps) are mostly where you find non-AHCI compatible hard drives.
As for your problem, have you installed Windows already and are switching to AHCI mode? If so, Windows will freeze since AHCI uses a different driver for the hard drive controller.
Casey