Does Microsoft support implementing Database Sharding using Sql Server 2008 R2 (any edition). From my limited understanding of it, I think, we could probably implement it using Sql Server Express. But I was not sure if Microsoft supports it or not.
Database Sharding Resource Link
Other than Distributed Partitioned Views, Data-Dependent Routing, what other options are available for Scale-out? (Peer-to-Peer Transactional Replication, Federated DB?)
Please share any URL that describe any implementation architectures in detail.
Thanks,
_UB
Best Answer
+1 to gbn. It's worth mentioning that SQL Azure does support sharding (federations) if you were considering other options.
http://social.technet.microsoft.com/wiki/contents/articles/1926.how-to-shard-with-sql-azure.aspx