I need some advice/articles to go through. We have a ecommerce website using SQL Server 2008 R2. For the searches we implement a ranking system using FullText and some other ranking criteria, for example, the amount of units that product has sold etc.
The search is working pretty well, but my manager wants to explore the use of NoSQL infrastructure to speed up our search results.
1. Can noSQL be completely integrated with SQL Server, so we can use the data in SQL to populate the NoSQL somehow?
2. Will we have the flexibility to modify our searches according to our specific business needs?
Any advice/articles pointing in the right direction will be appreciated.