Can SQL Server 2008 Scale Horizontally?

I have read that SQL Server cannot scale horizontally.开发者_开发问答 is this true?

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

---

No, it's not true.
SQL server can scale horizontally, using partitioning

---

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

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

---

Last week I heard about partitiondb, it really helped me. you just need to create one database that controls all partition databases and it manages them wonderfully. All you need is to declare your partitionid.

for example if your website is dealing with sales, you can partition your databases by storeid. then each store resides in different database instances or on a different server. all of them are managed from one template db, this gives the feeling of some sort of object oriented modelling.