I had one (and so far the only one) about 12 years ago. I still remember every second of that day because of the pain. I ended up going to 3different clinics (long story) before being directed to the hospital late that night. They ended up filling me with morphine. After I woke up a couple of hours later I had passed it. I had never been so happy when that pain was gone.
My daughter had a kidney stone a week later and she was only 14 at the time. I felt badly for her, but she passed hers rather quickly.
I drink plenty of fluids now just to keep everything flushing. I hope I never have to go through that again.