I believe the worst thing that can happen over clocking nowadays is that your card will be unstable. This usually happens when a card gets to hot, so you should watch the temperature, a value below 80°C should be fine. With Ati cards on Linux the command to get the temperature is
aticonfig --odgt
For Windows there should be some option in the driver (or third party software).