2008-04-15

Alen Ziver Malhasoglu's New Microsoft Commerce Server Blog

Understanding Ranking

Very useful query that uses FullText search is as follows:
USE Northwind;
GO
SELECT KEY_TBL.RANK, FT_TBL.Description
FROM Categories AS FT_TBL
INNER JOIN FREETEXTTABLE(Categories, Description, 'How can I make my own beers and ales?') AS KEY_TBL
ON FT_TBL.CategoryID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC;
GO
Here we see a column as "RANK". This column is used to compute a relevance of the found record with the search phrase. Following article explains the computation of this RANK value:
http://msdn2.microsoft.com/en-us/library/ms142524.aspx


Understanding Sql Server JOIN statements

Visualization of JOIN statements with simple explanations can be found at: