|
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...
|
|
|
Valid Data Types of Full Text Search Indexes
Full text search provides the ability to search documents and text within SQL Server. This video goes over what data types are valid when creating indexes. This includes text columns, word documents, etc.
|
Video Information
|
Publish Date:
|
November 06, 2008
|
Length:
|
3:57
|
Skill Level:
|
100
|
Rating:
|
4.10 out of 5
|
|
|
|
|
After watching you should be able to answer these questions:
- The CONTAINS clause is most similar to the following?
- When using contains in a query against a full text index, which of the following is not correct?
|
You must be logged in to view this video.
|
|
|
|
|
|
Comments:
|
|
The questions that displayed at the end of this video where not the ones for this video. The questions were covering the contains clause but the video was discussing what data types are valid for full text indexes.
|
|
|
ftu
|
|
|
The answers to the questions at the end of the video I'm sure were not actually mentioned during the video.
Also I still wasn't clear how you add a .DOC extension to a varbinary field.
|
|
|
Good presentation, but the quiz had nothing to do with the video.
|
|
|
Need more about how to index Word .doc files as varbinary(max) column values.
|
|
|
it is deprecated not depreciated
|
|
|
|
|
|
|