It varies quite a lot. One of my kids was needy all night long for most of a year, the other one started sleeping through the night maybe six weeks after we brought her home.
I've often thought that much of the difference between poor/adequate/great parents is the personality of the kid(s). Have a really easy one and then you think you're some of rockstar parent. Then number two comes along and shatters your delusions.
On top of sleeping, I like to add eating as very important to your own perception of how good a parent you are. :D
To be honest, with my two kids, how much they eat influences their sleep heavily as well. Unfortunately, my first has always eaten too little (he'd happily have his broccoli too, but never enough to be consider him fed), and the second is very picky (she eats a lot of what she likes, none of what she doesn't). When they eat well, they usually sleep well too.
