Let's say I have a lookup table of about 500,000 records rarely gets updated. And I have an
azure web site serving a single page that's doing a look up against this table. I know that I can increase the azure web role instances to handle large growth in traffic. But how does sql azure handle this growth? Does it do it automatically? Will the table get spread across different sql servers? ...