For months I had water spots on my car that wouldn't come out - I tried washing the car well, distilled white vinegar, a polishing compound, and nothing would work.
Then I tried a new product from the site that I purchase all of my car care products from (run by a professional detailer and perhaps the nicest guy you'll ever meet). It's called Spotless and here is a link to it:
http://www.carpro-us.com/auto-wash/s...remover-500ml/
You spray some over the area and gently massage it with a MF towel for awhile and then rinse it off with water. I was shocked and thrilled when I found out it worked.
My car is opti-coated, so I'm not sure if that will cause the results to differ, but so far this product has worked great for me and is something that I will always keep stocked in my arsenal. I'd definately try more conventional, or cheaper methods like a few of the ones I tried first as you'll have to pay for the product (which, imo, isn't a bad price) and shipping.
GL getting the water spots out - mine came from rusty water pipes dripping water from the ceiling in the garage I park at at work; it totally sucks having this sort of thing happen despite our best efforts to take care of, and protect our vehicles