The method you choose depends on the circumstances. If you and your wife are together, saying "Good night" in person allows for a more personal and intimate moment. However, if you're physically apart, sending a sweet text message can still convey your affection and thoughtfulness.