New word breakers may return different results in SQL Server 2012 Full-Text Search

If you rely on SQL Server Full-Text Search, then this is important information, even if you can’t recite the definition of word breaking and stemming. Word breakers identify word boundaries and break words into their components. Stemmers identify alternate forms of a word, such as “run,” “ran,” and “running.” Word breakers and stemmers are applied…


Custom proximity search with NEAR in SQL Server 2012

When you perform a proximity search with NEAR in versions of SQL Server prior to SQL Server 2012 "Denali," we decide what’s NEAR for you. In SQL Server 2012, however, you’re in control! With the new customizable NEAR operator, your full-text query can now specify 2 optional conditions that you couldn’t specify before: How near…