+1 Even some of the high dollar lenses need to be stopped down a bit to achieve their best optical performance. So it's always a balancing act between shutter speed, depth of field, ISO (and associated noise) and sharpness. There's a lot of factors to consider at any given time, and part of the art is deciding which you want to optimize at any given moment.
For a wedding, I may shoot a lot at f/4 on an f/2.8 lens, but if I need more power out of my flash, I can open up a stop to f/2.8, sacrificing a bit of depth of field, or I can bump my ISO up a stop, slightly increasing noise, or I can turn my flash up (not always possible with remotes) and lengthen my recycle time.
Natural light, restaurants, etc, I'm often shooting wide open at f/2.8 and adjusting ISO to keep a reasonable shutter speed. Sometimes I just have to hold really still and ask my subjects to do the same for a moment. Handholding at slow shutter speeds is quite possible with practice. This was shot under outdoor light at Skip's a month ago, at 70mm and 1/15th of a second.