Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
markpringle
Starting Member
11 Posts |
 Posted - 2011-07-20 : 10:45:04
|
| Because of the limits of shared hosting, I had to logically divide my growing MS SQL Server 2008 database into two databases. This has worked fine on shared hosting. However, I've now outgrown shared hosting and am moving to a VPS provider. I no longer have database size limitations. Should I consolidate back to one database? I can think of good reasons to do that, but don't know if having two databases logically divided has its advantages (maybe performance?). Help!"Kindness is not a weakness, the contrary on the other hand is." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-07-20 : 11:02:31
|
| There's no performance advantage by having 2 databases, at least nothing you couldn't reproduce in a single database. It's up to you and how much work would be involved in consolidating. |
 |
|
|
markpringle
Starting Member
11 Posts |
Posted - 2011-07-20 : 12:40:11
|
quote:
Originally posted by robvolk
There's no performance advantage by having 2 databases, at least nothing you couldn't reproduce in a single database. It's up to you and how much work would be involved in consolidating.
Thanks, it's much more work to consolidate, so I'd like to avoid that. "Kindness is not a weakness, the contrary on the other hand is." |
|
|
|
|
|
|
One SQL Server Database or Two (Multiple)?