SqlShare.com Logo
 
Skip Navigation Links
Home
Channels
Classes
About Us
Login / Register
Subscribe to the All channels feed  Goto the SqlShare.com blog
Image of Robert Cain
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...
Enhancing Searching of Full Text Indexes

Enhancing Searching of Full Text Indexes

Full text search provides the ability to search documents and text within SQL Server, but there are some tricks to making any search engine work better and FTS is no exception. Join SQL Server MVP Robert Cain for a look at searching for phrases and using proximity.

Video Information
Publish Date:
November 06, 2008
Length:
3:17
Skill Level:
100
Rating:
4.28 out of 5

After watching you should be able to answer these questions:
  1. When using NEAR in a full text query, how close will related words typically be?
You must be logged in to view this video.    

Bookmark and Share

  Rate This Video:  
 
1=Poor, 3=Good, 5=Excellent
Comments:
Kevin Shen on 2/25/2009
Great

AndreQ on 2/25/2009
would have been helpful saying how to set up the full text index

Robert Cain on 2/26/2009
AndreQ - If you click on my name you will see a list of all the videos I have done. Included is one on the very subject you asked for. http://www.jumpstarttv.com/creating-a-full-text-search-index_548.aspx shows how to setup the index.

Daniel Jordan on 2/26/2009
Nice and clear.



Must Be Logged In

References
Sponsored Ads
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions