Which is better in night prayer: long standing (Qiyam) or long prostration (Sujood)?
Long standing (Qiyam) is better in prayer. However, a Muslim should also observe tranquility and composure in their prayer.
Is it permissible for women to gather in one of their homes to pray Tarawih?
Yes, it is recommended (mustahabb) for women to pray Tarawih in congregation if they gather, even if it is not in the mosque.
In fact, praying at home is better for them, as it avoids the potential concerns associated with going to the mosque.
Is it valid to perform the obligatory prayer while sitting?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
Standing (Al-Qiyam) while having the ability to do so is one of the pillars (Arkan) of the prayer; the obligatory (Faridah) prayer is not valid without it. However, whoever is unable to stand may pray sitting down. As for voluntary (Nafilah) prayers, it is permissible to pray them sitting even if one is able to stand, but the one sitting receives half the reward of the one who prays standing. And Allah the Exalted knows best.
Should a prayer performer who forgets to offer the middle Tashahod (saying ash-hadu anala ilaha ila-alah) offer Sujood As-Sahw (prostration of forgetfulness)?
He/she should offer two prostrations of forgetfulness at the end of the prayer. And Allah Knows Best.