SQL Server Full-Text Search (FTS) Blog
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...
Author: Douglas Laudenschlager 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...
Author: Douglas Laudenschlager 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...
Author: Douglas Laudenschlager 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...
Author: Naveen Garg 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...
Author: Sudarshan Narasimhan [MSFT] 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...
Author: Naveen Garg 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...
Author: Naveen Garg 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...
Author: Sudarshan Narasimhan [MSFT] 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...
Author: Sudarshan Narasimhan [MSFT] 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...
Author: Sudarshan Narasimhan [MSFT] 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...
Author: Fernando Azpeitia 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,...
Author: Fernando Azpeitia 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...
Author: Fernando Azpeitia 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...
Author: Fernando Azpeitia Date: 12/03/2009
Welcome!
Welcome to our official SQL Server Full-Text Search (FTS) Blog! This blog was just born recently J....
Author: Fernando Azpeitia Date: 11/30/2009