获取相关项目的最佳SQL 2005查询？

I have a small video site where I want to get related videos on the basis of the most matched tags. What would be the best MSSQL 2005 query to get the related videos?I have a small video site where I want to get r