http://social.technet.microsoft.com/Forums/en-US/w7itproinstall/thread/035fe8f6-a1f7-426a-b4dc-e9987... discusses your issue - STOP 0xF4 on resume from sleep after installing SP1. It offers 2 solutions in the thread:
A) Post by Imperial College ICT
Solution
1.Boot into BIOS Setup
2.Go to Power options
3.Change the "ACPI S3 Hard Disk Reset" option to "Enable"
4.Restart
I don't know if the latest G74SX BIOS has a comparable setting, but I'll let YOU do the checkin'! :>{)>
B) Post from mpok3 at the end of the thread
In the Local Area Connection Properties, click Configure... On the Power Management tab,
untick 'Allow the computer to turn off this device to save power'.
You might also check if you have the latest firmware update for your Corsair SSD.
Does the BSOD occur after hibernate? If not, having the laptop skip sleep and go directly to hibernate could be a possible workaround which may or may not be acceptable to you.
Give these a try and let us know if it resolves your issue.
G74SX-A1 - stock hardware - BIOS 202 - 2nd Monitor VISIO VF551XVT