This article shouldn't flat out make the decision for you, but these concerns raised by the guys at StackOverflow (over SQL Server 2008) helped guide us toward Solr:
http://www.infoq.com/news/2008/11/SQL-Server-Text
--
Hector
On Dec 7, 2011, at 2:17 AM, Mersad wrote:
> hi Everyone,
>
> I am wondering how much benefit I get if I move from SQL server to Solr in my
> text -baed search project.
> Any help is apprechiated !
>
>
> best
> Mersad
