Presentation on SQL Server 2008 Full-Text Search: iFTS (integrated FTS)

Hi All,  Several weeks ago I had the privilege to present SQL Server Full-Text Search at PASS 2009, here in Seattle. This presentation was part of a larger session targeting how to manage unstructured and semi-structured data in SQL Server 2008. The session was an overall success, aiming the main pain points and best practices our…


‘Gotchas’ on searching for ‘AT&T’? ‘M&M’? etc..

Generally, WBs will parse the ‘&’ character as a separator and therefore emit the terms on both sides of this character. We already posted on this blog how to avoid this default behavior by using custom dictionaries.  Note the following though, SQL Server Full-Text Search Parser will see this character as an abreviation of an AND,…


Creating Custom Dictionaries for special terms to be indexed ‘as-is’ in SQL Server 2008 Full-Text Indexes

  Did You Know?:  That SQL Server 2008 provides the ability to create a Custom Dictionary of special terms to be indexed ‘as-is’ (i.e: ‘AT&T’) into the FTIndex?…    Many times you find yourself in a situation where you would like to index a given word/term ‘as-is’ in your Full-Text Index. However, due the specific…