SQL Server Full-Text Search (FTS) Blog

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...

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...

Statistical Semantic Search , which is new in SQL Server 2012 “Denali,” indexes documents and text columns to support queries that go beyond the simple keyword search of LIKE or of Full-Text Search. Semantic Search lets you query for 3 types of information...

We are very excited to introduce a new Statistical Semantic Search feature with Fulltext Search in Denali . With an optional new parameter ‘statistical_semantics’ you can now augment your Fulltext keywords index with two new indexes –...

In this post I will cover how to get a custom IFilter working on SQL Server 2008/R2 (64-bit or 32-bit). For the purpose of this demo, I am using the IFilterSample that is available with Windows Server 2008 SDK. Once you have installed the SDK you can...

Fulltext Search codebase has been significantly revamped to address both query performance and throughput on large scale (millions of documents) with concurrent updates. With SQL2008 we moved all the index storage in the database file and majority of...

SQL Server 2008/R2 Fulltext Search Fix for improving queries performance during concurrent index updates - http://support.microsoft.com/kb/958947 As you may already know, Microsoft has made significant improvements since SQL Server 2005 to fully integrate...

In this post I will cover how to get a custom word-breaker working on SQL Server 2008 64-bit instances. Many of you out-there might already be familiar with an old sample that shipped with Windows Platform SDK called LRSAMPLE . I am going to use this...

Continuing on my last post which dealt with Chinese characters, I will cover some user scenarios on Germanic characters like German/Swedish/Norwegian with SQL FTS. Read on... Scenario1 – German language Mr Customer : Hey, we have some...

As part of my work I come across varied scenarios that customers encounter with SQL Server. I recently had the opportunity to work on some interesting scenarios using SQL Full-text search and international characters (non-English). To most people, the...

Recently, we got the following valid question: I have something like : SELECT line FROM text1 WHERE CONTAINS(line, '"Good" Day"') I get a Msg 7630 error because of the apostrophy in the middle of the phrase, but that is a part of...

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. ...

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,...

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...

Welcome to our official SQL Server Full-Text Search (FTS) Blog! This blog was just born recently J . We, the SQL Server FTS team, are planning to start posting here tons of useful information related with our Full-Text Search (FTS) feature in SQL Server...