|
Author:
Author Bio:
Robert C. Cain is a Microsoft MVP in SQL Development, and works as a Senior BI Architect for ComFrame. His main responsibility is the SQL Server Business Intelligence Data Warehouse for the NASA ARES project. He is also a contributing author to the book "SQL Server MVP Deep Dives". Prior to his current position, Robert spent five years working for a south eastern nuclear power company designing an...
|
|
|
Ordering Full Text Index Search Results by Relevance
Full text search provides the ability to search documents and text within SQL Server. There are several ways to query full text indexes. This video by MVP Robert Cain shows you how to return the results of a full text index query ordered by relevance.
|
Video Information
|
Publish Date:
|
November 06, 2008
|
Length:
|
5:0
|
Skill Level:
|
100
|
Rating:
|
4.47 out of 5
|
|
|
|
|
After watching you should be able to answer these questions:
- When using FREETEXTTABLE, what is RANK used for?
- FREETEXTTABLE takes 3 parameters - do you know what they are?
|
You must be logged in to view this video.
|
|
|
|
|
|
Comments:
|
|
Just what I was looking for...
|
|
|
Very good info! and very clearly spoken at a pace that was easy for the user to follow. Brian Knight needs to speak like you do when teaching SSIS topics....
|
|
|
v.good
|
|
|
I really enjoy this little nuggets of information.. You guys are the hardest working SQL experts to share this.
|
|
|
It would be great if it discussed which rank value is a better match, a low number or high number.
|
|
|
Great stuff
|
|
|
|
|
|
|