When and how should is it recommended to raise the hands in prayer? I have seen some do it only at the opening takbir, while others do it at various points throughout the prayer, so what is the sunnah?

It is recommended for any takbeer during the prayer.