My cousin was stationed in same place for 15+ years - army. He did have to do training in other places at times - but he was divorced and they kept him near his kids.

My buddy - Air force- got relocated once As infinity, married and kid - it's been 9 years and they kept him there.

My brother-he didn't care where he lived until he settled down sso this is his 3rd post, and he's got kids now-still married to same woman but her life is there and she'd be devastated, so he's put in all necessary ppwk and kept his boots clean so he wouldn't move. His currently superior has planned out his contract with specialty tasks requiring his stay there and then when he renegotiates contract it'll be under condition he stays or Gets out