Is muscle soreness really a sign of an effective workout?

For a lot of guys, the soreness you feel in your muscles after a tough workout could be even worse than the discomfort you feel powering through the actual exercises. Source