Just how big can a super-Earth get while staying 'habitable'?

But could these giant, rocky planets actually sustain the conditions for life? Or is life limited to smaller planets like our own?