@golf07 - I can't speak for most people, but I can speak for myself! I am middle aged, and have always had some shooting type pains that have only lasted a quick second. I have experienced them in just about every part of my body, not just my legs.
As a child I had some leg muscle pain at night, and figured it was "growing pains". It must have been, because I do not have them anymore.
There is never any rhyme or reason why or when these quick, sharp pains happen. They are over almost as soon as they begin. I don't think they are all that uncommon. My mom has the same thing happen to her.