Can we span the SQL server to multiple machines

When the database is becoming huge, how to divide it and span t开发者_C百科o multiple servers?

How huge? Single instance SQL Server deployments are capable of handling peta-byte databases.

For scale-out one option to look at is Peer-to-Peer Transactional Replication, which can do an in-place scale-out of an application not explicitly designed for such.

Applications that are designed for scale-out ahead of time have more options, for instance consider how MySpace spans over individual 1000 databases by using a message buss.

For more specific answers, you have to provide more specific details about your real case.