The SMS will come in as soon as you take it off of airplane mode.
Most networks have a text that will come in as well letting you know what calls you missed. All calls will go directly to voicemail so if someone really wanted to contact you they would have left you a voicemail.
Otherwise if you're so bothered, put your phone on silent and shut vibration off. Or put the phone in a different room so it doesn't bug you and buy and alarm clock.