Relevant search results using SQL

This is a good article on how to approach relevance searching using SQL. Nice and simple. 

http://www.jarrodgoddard.com/web-development/advanced-web-site-search-with-sql

Here is a great article on FULLTEXT searching with relevance in MySQL:

http://www.tuxradar.com/practicalphp/9/3/18

Here is how to do FULLTEXT searching in SQL:

http://msdn.microsoft.com/en-us/library/ms189760(v=sql.105).aspx

How do I know if a table has a full text index on it?

http://stackoverflow.com/questions/940386/sql-server-fti-how-to-check-table-status