Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Official blog managed by the SQL Server Full-Text Search engineering team
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...
Date: 11/18/2011
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...
Date: 11/15/2011
Looping over document similarity details in Semantic Search
Statistical Semantic Search, which is new in SQL Server 2012 “Denali,” indexes documents and text...
Date: 10/31/2011
Introducing Fulltext Statistical Semantic Search in SQL Server code name 'Denali' Release!
We are very excited to introduce a new Statistical Semantic Search feature with Fulltext Search in...
Date: 07/21/2011
Getting a custom IFilter working with SQL Server 2008/R2 (IFilterSample)
In this post I will cover how to get a custom IFilter working on SQL Server 2008/R2 (64-bit or...
Date: 07/13/2011
Fulltext Search Improvements in SQL Server code-named 'Denali' CTP1
Fulltext Search codebase has been significantly revamped to address both query performance and...
Date: 06/02/2011
SQL Server 2008/R2 Fulltext Search Fix for improving queries performance during concurrent index updates
SQL Server 2008/R2 Fulltext Search Fix for improving queries performance during concurrent index...
Date: 04/12/2011
Getting the LRSAMPLE custom word-breaker to work on 64-bit SQL Server 2008
In this post I will cover how to get a custom word-breaker working on SQL Server 2008 64-bit...
Date: 12/10/2010
Part2 - SQL Full text Search and International Characters: Interesting Scenarios, solutions and deep-dive using DMV’s
Continuing on my last post which dealt with Chinese characters, I will cover some user scenarios on...
Date: 12/10/2010
Part1 - SQL Full text Search and International Characters: Interesting Scenarios, solutions and deep-dive using DMV’s
As part of my work I come across varied scenarios that customers encounter with SQL Server. I...
Date: 09/02/2010
Escaping special characters in FTS. i.e:How to use double quotes within a phrase itself?
Recently, we got the following valid question: I have something like : SELECT line FROM text1 WHERE...
Date: 12/21/2009
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,...
Date: 12/15/2009
'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...
Date: 12/09/2009
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...
Date: 12/03/2009
Welcome!
Welcome to our official SQL Server Full-Text Search (FTS) Blog! This blog was just born recently J....
Date: 11/30/2009