Useful Sql Server Full Text Search System Views

Full text search provides the ability to search documents and text within SQL Server. This video shows you some useful system views that offer insight to your full text index metadata.

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...

Steve Harris on 5/12/2009

hard to follow as to why you would need this information. perhaps a video before this one explaining what full text searches are, how to use them and how they are created would be helpful.

Leonard Peoples on 5/12/2009

Great video. I would like to see on on how to setup full text cataloging from start to finish. Thanks

Jamshid Nouri on 5/12/2009

excellent video

Travis on 5/14/2009

Would have been nice if the author would have attached the code as well.

Marshall Cole on 5/19/2009

Thank You!! This is very helpful information, and I appreciate the time you have taken to help others. Citidirect Global systems support Marshall Cole

Tonci on 11/18/2009

Those queries using sys schema views, together with those schema functions, are advanced. Great work and thank you.

A4A72D151B on 10/4/2011

haven't actually worked with full text catalogs but I know I will eventually need these skills

D151BB6B9F on 10/4/2011

Again, it'd be nice if we could download the query he built.