140 reputation
15
bio website ricardodsanchez.com
location Austin, TX
age
visits member for 4 years, 11 months
seen Sep 11 at 3:02

Are you on Twitter? let's connect: @ricky


Sep
24
awarded  Autobiographer
Sep
11
awarded  Scholar
Sep
11
awarded  Supporter
Sep
11
accepted One Database vs. Multiple Databases
Sep
11
accepted how do companies like Google and ebay deploy new versions of their sites without downtime?
Dec
6
awarded  Notable Question
Jan
24
awarded  Popular Question
Jun
30
asked how do companies like Google and ebay deploy new versions of their sites without downtime?
Mar
23
comment Can I run SQL Server Management Studio in Windows 7?
@Joe Thanks, I am aware of that and I am glad you posted this comment so everyone else is aware of it too :)
Jan
31
comment One Database vs. Multiple Databases
If I end up with 100,000 clients, I am sure I'll have enough resources ($$) to throw at the problem then... :) I see your point, however I am inclined to believe that one db per customer is better for all the reasons posted here by others. I will also think that with that many databases I would probably spread them to multiple SQL server instances. Thanks for your input!
Jan
30
answered Can I run SQL Server Management Studio in Windows 7?
Jan
30
comment One Database vs. Multiple Databases
Thanks for your input. Wouldn't be just a matter of running the same scripts in all databases when a change in the schema is needed? I'm just guessing... I haven't have the need to do this yet but does not seem as a difficult task, but I could be completely wrong and that is the reason I am asking :)
Jan
30
awarded  Student
Jan
30
comment One Database vs. Multiple Databases
You are absolutely correct about moving data easier by having separate databases and having the ability to take one client's db and set it up in a different server if needed.
Jan
30
comment One Database vs. Multiple Databases
Good point about the backups/restore, thanks for the advice.
Jan
29
asked One Database vs. Multiple Databases