I am looking for some suggestions on a database design. I am building a public site that will have a lot of users. each user will have a client database that they will be uploading and managing for various tasks. I am using MS SQL 2008 if that makes a difference
My Question is, lets say we were designing this app to handle 2mil people ++, would it be better to have everything in 1 large database, or have each person / company have its own database and why?
ANY help given would be greatly appreciated, and thanks in advance!