Most people, in my own opinion, misunderstand what it means to play tight. Tight doesn't, necessarly, mean playing premium hands only - it means simply being selective on the hands you play and when. Position and who's in the pot should generally effect what hands you'll play (as well as blinds/stacks).
But of all styles, aggression is what wins most of the money. This, also, doesn't mean always betting. It means betting when you smell weakness and/or have a hand. Though, if you bet whenever you get a hand and check whenever you've missed, you'll be easy to read. On occassion you'll have to slow play as well as bluff. If you seldom bluff, you should probably show it - just to keep them guessing. On the other side of the coin, if you're better at playing people, you'll want to show your good hands. Basically create an image opposite of how you normally play.
But whichever style you like best, you'll need to change how you're playing based on how the table is playing. I've heard professionals recommend playing the opposite as the rest of the table - if they're playing tight then play loose and vice versa. This is especially true in no limit. The question should be, "how am I going to play this person", as apposed to, "how am I going to play the cards I'm getting cards".