|
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...
|
|
|
Creating a Full Text Search Index
Standard indexes are used to make queries run faster when using simple operators like equal and greater than/less than. Full text indexes are used to make queries run faster than need to look for embedded text within a text type column. Join Robert Cain for a look at how to create these special indexes.
|
Video Information
|
Publish Date:
|
November 06, 2008
|
Length:
|
5:2
|
Skill Level:
|
100
|
Rating:
|
4.18 out of 5
|
|
|
|
|
After watching you should be able to answer these questions:
- Which of the following best describes the requirements for creating a full text index?
- What action must be taken before creating a full text index?
|
You must be logged in to view this video.
|
|
|
|
|
|
Comments:
|
Thomas Kaiser on 11/11/2008
This is a great way to learn, especially since the topics are brief, and the next video is suggested in the dialog box on this comment form.
Thanks for this excellent service!
|
|
|
thanks.
|
|
|
another excellent video
|
|
|
really gud
|
|
|
1. Would appreciate if you type less (keep most of the SQL queries already typed in the Query Window) and focus more on speaking/demoing part.
2. Make your code available, if somebody wants to try it later
3. How does one find out where the catalogs are, you should have atleast pointed us to that.
4. Best way to demo in my opinion is
-- Comment 1 : What the next line does
Write your SQL COde
-- Comment 2 : What the next line does
Write your SQL COde
-- Comment 3 : What the next line does
Write your SQL COde
Finally you highlight all 6 lines (might be 6+ in your case) and execute it
|
|
|
|
|
|
|