Category Archives: SQL Server

Full-Text Search with SQL Server 2008

Posted on April 17, 2011 by

The full-text search capabilities of SQL Server 2008 make it possible to search text across multiple columns, weight search terms, and search by proximity. A full-text query can be much faster than the equivalent LIKE query. The first step is … Continue reading →

Posted in SQL, SQL Server | Leave a comment

Checking if FullText Service is installed on SQL Server 2008

Posted on January 3, 2011 by

SELECT FullTextServiceProperty(‘IsFullTextInstalled’) This will return 1 if the service is installed.

Posted in SQL Server | Leave a comment