Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


share|improve this question
up vote 1 down vote accepted

+1 to gbn. It's worth mentioning that SQL Azure does support sharding (federations) if you were considering other options.

share|improve this answer
Thank you, this is useful. – UB01 May 15 '12 at 14:25

No, SQL Server doesn't support sharding. SQL Server scales up not out.

This applies to RDBMS in general:

  • CAP theorem says you can have at most 2 of C, A and P.
  • RDBMS are ACID compliant which is the point of using them

The "C" in both acronyms is "Consistency" and sharding sacrifices "Consistency"
So generally sharding and consistency are mutually exclusive

There are exceptions (more or less) of course. Some examples:

share|improve this answer
Thank you. From what I know, there are some options available to scale out with Sql Server. I can't recollect the details, but it is possible. In database Sharding, Consistency is not impossible. There is lot of architectural planning that is needed though. I have not heard of CAP theorem, but I will read the article. – UB01 May 15 '12 at 14:18
I didn't say not impossible, but it isn't generally done. For scale out, see – gbn May 15 '12 at 14:27
Thank you, it is useful. Though the answer is not what I would like to see, it is what it is. – UB01 May 15 '12 at 15:18
Scaling Out SQL Server : – clickstefan Dec 17 '14 at 14:13
@clickstefan: none of those are real "scaling out" in the sense of "add more nodes" – gbn Dec 22 '14 at 13:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.