Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

Can SQL Server be sharded for distributed data processing? Or are there any limitations that prevent relational databases from being sharded ?

share|improve this question

SQL Server has a feature called "distributed federated views" or sometimes "partitioned views". (Confusingly, this is very different that the "partitioned tables" feature introduced in SQL Server 2005.)

The distributed federated views feature allows a crude, inflexible sort-of-sharding. It has been in the product since SQL Server 2000. I have never personally seen anyone use the feature and be happy with it. Here is a blog entry that covers the feature a bit:

In short, Microsoft does not provide easy-to-implement support for sharding in the box. You can always build your own sharding system that uses SQL as the storage layer. I would look through CodePlex and SourceForge before trying to write my own.

Sorry for the formatting, I'm on a phone.

share|improve this answer
Distributed Partitioned Views are not updatable except in Enterprise Edition. – Greg Askew Jan 12 '13 at 16:01

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.