Need some advice. We're starting to outgrow the server that we're using for our datbase that is the back-end of a Cold Fusion website. What's the best way to go?
One option is to just buy a bigger server and move the datbase to that one.
Other than that option, what is the deal with adding MORE (scale out) servers. Is that datbase partitioning, or is that something else, and in a broad sense how does that work? Does each server have a copy of SQL server installed on it, and each database would be different, containting different information? (I.E. one database contains a certain set of tables like customer data, and the other database contains other tables like order data).
I keep hearing about database partitioning, and can't figure out if that's what I'm looking at doing by using two different computers, or if that's called something else.
Also if I'm using to servers with databases on them to improve performance, does it matter if I use SQL server Enterprise or Standard?