for our our client, I should develop a small sample application for the cloud.
Today we have a database in which codes are stored. The database growth heavily, at the moment we have 250 Million rows in one table. Therefore I want to implement a windows azure based service which will generate new codes, store the codes and a webservice which will get back the codes to a client application. The codes are formated in numeric and alphabetical manner with a lenght off 13 characters, sample: "123GH45SD788".
So my question is, how you would implemt the solutation: SQL Server Azure, partitioning and then how to save the code in the partition tabels for best performnace.
