I leave it on most of the time - but I do turn it off when I'm converting movies with Handbrake to import into iTunes. If I don't, it ends up grabbing the temporary copies from the desktop before I've imported them, and makes my backup larger.
For those not using it, the attached describes how Time Machine automatically archives backups.