Partager via


SQL Server Full-Text Search (FTS) Blog

Official blog managed by the SQL Server Full-Text Search engineering team

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

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