Here are a couple of examples of what I mean. I was using an HP point and shoot camera.
First shot taken rushing out of MK. Hand held and blurry. Knew it was no good, so...
Second shot still hand held, but I believe I leaned against a pole or something, placed the camera against my forehead and held my breath (the latter being a trick my father taught me when I was a kid using our new Polaroid, LOL). Had I used a tripod or rested the camera on a firm surface it would have been even better but for whatever reason I didn't. Buildings relatively clear (they're still) but people are blurred (they're moving). A faster shutter speed would have improved the people blur, but at the time I didn't know how to do that.
My point is, like YEKIM said above, with any camera you can improve your results by learning/understanding a few basic things. Keeping the camera still is really key when taking night shots. (Second shot is my entry for this week's weekly photo contest.)