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 find the sample here -> C:\Program Files\Microsoft...

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 population logic in to the core engine to make fulltext...

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 full-text search components inside the SQL...

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 as a sample reference and must warn you this post...

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 full text search catalogs for German words...

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 concept of word-breaking especially with non-English...