I was reflecting on the two "great banes" of military in DF as it is now (unmodded).
1.) A nervous-system wounded dwarf is pretty much useless in the military, and if they are champions then they can never be released from the military job (I have seen this happen).
2.) If the squad leader gets distracted and wanders off to drink, eat, or sleep, then the entire squad leaves. This can obviously be bad if they're waiting for a bunch of siegers to attack or something.
My solution: Military Administrators! Essentially, a soldier who doesn't participate in combat, but counts as a leader so that the other dwarves do their jobs. Since he isn't combat-military, it would be a good place to stash your nervous-wounded dwarves, so they are still serving, but their low combat skills from no sparring wont screw everyone up.
What I was thinking that would be interesting, is if the admin was required, perhaps 1 per 10 dwarves in a squad, and they also function as a quartermaster, by carrying needed equipment to the barracks (or other defined military pickup) so you could better manage what your dwarves were using and to prevent the soldiers from doing it during battle.
Also, one could make it a skill, and have a bonus come from having a good administrator(s) running squads, probably a speed boost, combat boost, or exp boost.