Why not to use MS SQL Server

The Keyword column corresponds to some representation of a single token extracted at indexing time. What makes up a token is determined by a component of the full-text engine called a “word breaker.” Each language supported by full-text search has a word breaker component that breaks a text stream into individual tokens based on the rules for word boundaries of that particular language.

Except Turkish MS SQL Server 2005 supports all languages that’s why you can not use full-text search efficiently in Turkey. If you have to use MS SQL Server 2005 you should try Lucene for search purposes.

MSDN documentation mentions full-text search improvements on MS SQL Server 2005, I can not imagine how terrible MS SQL Server 2000 was …


Leave a Reply

Your email address will not be published. Required fields are marked *