I switch between three different holes on my Sport band depending on what's going on. For a workout, I use the most-snug of the three, if for no other reason than to make sure it doesn't move at all. I wear it at its loosest when it's warm or when I'm sleeping. Most of the time, it's in between.
It's randomly locked itself maybe once since I got it last August, so it's doing pretty good.