Sprite sizes?

Hi im wondering how big I can make sprite's. I mean the bigger the images are the more detail right? so why not use a bigger size like 128x128 for the main character and like 700x600 for a building. Why use smaller sprite's like 32x32 and 100x70?