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: 445
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