We have our stairs carpeted and the lower floor is tiled - so on the bottom stair step the carpet just finishes.
Where the stair carpet finishes it's a bit untidy, the carpet is quite deep so there's often little bits of thread sticking out etc.
Also our dog sits there when we're upstairs...