While there is no practical limit to object sizes (the ScaleOut service allows individual objects up to 1GB), network bandwidth and access patterns will determine the maximum size that your environment can handle. Realistically, it takes about 15 seconds to move a 1GB object over gigabit...