Texture choice?

Hi, I'm wondering how you guys know which texture to use - 'cause I have no idea. Is there some kind of guideline to it, other than trusting your instincts? How do you know what setting you choose for the textures?

If there are links to tutorials, that would be awesome.