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.
What is Tarawih prayer?
Tarawih prayer is the night prayer (Qiyam) performed during the month of Ramadan. It is called "Tarawih" because Muslims used to prolong the standing (qiyam) in it and take brief rests after every four rak‘ahs.
Is it obligatory to have an intention (niyyah) for every prayer?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
It is obligatory for the worshiper to have a specific intention (Niyyah) for every prayer, meaning they must consciously intend the act of worship they are performing. The intention is a pillar (Rukn) of the prayer, and the prayer is not valid without it. It is not a requirement to utter the intention verbally; rather, doing so is considered a recommended Sunnah. And Allah the Exalted knows best.
What is the ruling on swearing an oath by the Prophet ﷺ, and does such an oath take effect according to Imām Aḥmad ibn Ḥanbal, requiring expiation upon its breach?
All praise is due to Allah, and peace and blessings be upon our master the Messenger of Allah ﷺ.
Swearing an oath by a created being is disliked (makrūh) in our Shāfiʿī school. Shaykh al-Islām Imām al-Nawawī, may Allah have mercy upon him, states: "Swearing by a created being is disliked — such as swearing by the Prophet, the Kaʿbah, Jibrīl, the Companions, or the Prophet's family. Al-Shāfiʿī, may Allah have mercy upon him, said: 'I fear that swearing by other than Allah the Almighty may constitute an act of disobedience.' The scholars of the school explained this to mean: that is, something forbidden and sinful — indicating that he had some hesitation in the matter. Al-Imām stated: the established position of the school is that it is categorically not forbidden, but rather disliked. Furthermore, whoever swears by a created being, his oath does not take effect and no expiation (kaffārah) is required if he breaks it." [Rawḍat al-Ṭālibīn wa ʿUmdat al-Muftīn, Vol. 11/P.6]
According to the Ḥanbalī school, however, expiation becomes obligatory upon one who swears by our master the Prophet ﷺ and then breaks his oath. Imām al-Bahūtī al-Ḥanbalī, may Allah have mercy upon him, states: "No expiation is required for swearing by other than Allah the Almighty, even if the oath is broken — because expiation was made obligatory for swearing by Allah and His attributes, out of reverence for His names, and nothing else is equal to Him in this regard... except in the case of swearing by our Prophet Muḥammad ﷺ, for expiation becomes obligatory when one swears by him and then breaks the oath. This was explicitly stated in the narration of Abū Ṭālib, because he is one of the two conditions of the two testimonies of faith by which a disbeliever becomes a Muslim. Ibn ʿAqīl held the view that swearing by any of the other prophets, peace and blessings be upon them all, carries the same ruling." [Sharḥ Muntahā al-Irādāt, Vol. 3/P.441]. And Allah the Almighty knows best.