Can the SQL Server 2008 scale scale horizontally?

Question

I read that SQL Server cannot scale horizontally. it's true?

I am planning a high traffic website and am looking for a database that can easily scale across multiple servers.

Answer 1

No, it is not. SQL Server can scale horizontally using split

Answer 2

More recently, SQL 2012 has more features for horizontal scaling.

http://robtiffany.com/building-microsoft-meap-scaling-out-sql-server/

Answer 3

I heard about partitiondb last week, it really helped me. you just need to create one database that manages all the partition databases, and that manages them perfectly. All you need to do is declare your section.

For example, if your site deals with sales, you can split your databases into storeid. then each store is located in different database instances or on a different server. they are all managed from the same db template, which gives the feeling of some kind of object-oriented modeling.