Full Text Searching

Full Text Search Follies

  • Article

Are you considering upgrading from SQL Server 2000 to SQL Server 2005? Are you using Full-Text Search? One of the top SQL Server consultants in New York walks us through an interesting issue that you might want to consider before migrating your databases.

4.59 (17)

2008-01-18 (first published: )

14,931 reads

SQL Server Full Text Search Language Features, Part 2

  • Article

This is the second of a two-part article that explores the language features of SQL Full-text Search (SQL FTS), an component of SQL Server 7 and above that allows fast and efficient querying of large amounts of unstructured textual data. Part I dealt with index time language options, covering how words or tokens are broken from the text stream emitted from the iFilters and stored in the index.


2,945 reads


Setting default values for Array parameters/variables in Azure Data Factory


(2020-Aug-14) Setting default values for my parameters or variables in Azure Data Factory (ADF)...

Daily Coping 13 Aug 2020


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – August 2020 – More DML Triggers


Well, I’m running a bit late. Both for this month and the fact I...

Read the latest Blogs


Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

trouble with exec @sql

By polkadot

I want to search all databases having sprocs containing text 'text I am looking...

BDC Orchestration

By Steve Jones - SSC Editor

Comments posted to this topic are about the item BDC Orchestration

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers