New DMF for SQL Server 2008 sys.dm_fts_parser to parse a string

Posted on SQL Server Central See other posts from SQL Server Central
Published on Fri, 17 Dec 2010 07:00:00 UT Indexed on 2010/12/17 17:09 UTC
Read the original article Hit count: 439

Filed under:
Many times we want to split a string into an array and get a list of each word separately. The sys.dm_fts_parser function will help us in these cases. More over, this function will also differentiate the noise words and exact match words. The sys.dm_fts_parser can be also very powerful for debugging purposes. It can help you check how the word breaker and stemmer works for a given input for Full Text Search.

© SQL Server Central or respective owner