In most cases, Tight-Aggressive (TAG) is what gets the money.
Gus Hansen, himself, said in Every Hand Revealed that he wished he knew whether LAG or TAG was the optimal approach.
A LAG strategy better conceals your hand, and makes you more difficult to read. And it obviously gives you more opportunities to make big hands, as you see more flops. But, this approach can melt your stack, if you can't spike a good hand.
A TAG tag strategy compresses your range, giving you less chances to make a good hand. However, TAG is far less dependent on paper, than LAG. Your bets will get more respect, allowing you more opportunities to steal pots pre-flop with a raise, or post-flop, via aggression.
As it relates to limping, TAG often endorses suited-connectors and pocket pairs. LAG can be anything from suited-gappers (or even suited-double gappers) to any two connected cards, and much, much worse.