I think it really depends on the age of the dog. I got my dog at 8wks, and I'd say for at least the first month, we took him out for a potty break once in the middle of the night. It helped if I limited his water intake 2 hrs before bedtime. don't take water away - just monitor the amount. (i.e. don't let him drink the whole bowl)
I also found that he slept great when he was allowed to sleep WITH us. for some reason, sleeping "with the pack" made him sleep more soundly, and not wake up for potty break or playtime. of course, I only attempted this once he was housebroken and had a basic understanding of the house rules (no cat chasing, chewing or accidents).
now that he's 1-1/2 yrs old, I have to DRAG him out of bed. If he had it his way, he'd sleep in until 8am every morning. I get up at 6:30am, he goes out to the bathroom, comes in, and goes right back to bed.