Friday, December 3, 2010

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

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]

No comments:

Post a Comment