I was starting to panic because suddenly my 1TB Seagate SATA drive wasn't working, I thought it was a BIOS issue because it seemed to have happened after I tried overclocking my Desktop too much.
I tried powering down and waiting, but I still couldn't hear the drive spin up at all. I tried a second 1TB hard drive and it wouldn't work either. I checked all power connections again and again until one of the pins in the MOLEX connector popped completely loose.
This was a small problem but who knows how long one could troubleshoot not knowing it is the connector ? It looked fine until I moved it by accident and the pin moved completely out of the socket.
I guess if a drive is not being detected I always remember this and to ensure the pins in any MOLEX are good. It's a relief and a big embarassment that the problem with my 1TB Seagate SATA drive was just because of 1 loose pin on the MOLEX power connector.