Today's MSSQLTips.com newsletter has a nice article on sys.dm_fts_parser. I didn't know it existed. I need to get my head out of the shell more often!
New DMF for SQL Server 2008 sys.dm_fts_parser to parse a string
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 [more]
Post a Comment