SQL Server vs SOLR (Or any document db)
Many NoSQL products have sharding built-in.  The DBMS itself looks after storing a particular key range on a certain server and keeping redundant copies for high availability.  Client connections are routed within the DBMS rather than in the application.  Multi-server scale out becomes easy, at the cost of CAP compromises.