-
Recent Posts
Archives
- July 2016
- April 2015
- January 2015
- October 2014
- September 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- January 2014
- August 2013
- March 2013
- February 2013
- January 2013
- December 2012
- June 2012
- April 2012
- March 2012
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
Categories
Blogroll
Meta
Category Archives: SQL Server
Full-Text Search with SQL Server 2008
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
SELECT FullTextServiceProperty(‘IsFullTextInstalled’) This will return 1 if the service is installed.
Posted in SQL Server
Leave a comment
Jenny's Jottings 