SQL Server Full Text Searching

This site has supporting documentation for my "Getting Started with SQL Server 2005/2008" presentation. Please note that in the downloads section I have created a release for each of the major components. There's one release for the slide deck, one for the SQL Server Management Studio code samples, one with the WPF project, and one with the StopWords/StopLists demo. Be sure to scroll through the list of releases in order to see everything.

Detailed descriptive material can be found on my blog, ArcaneCode.com, with links to specific posts below.

First off, the slides and sample code can be located at the Code Gallery site I setup specifically for Full Text Searching with SQL Server:

http://code.msdn.microsoft.com/SqlServerFTS

Look on the downloads page to see various projects around SQL Server Full Text Searching. I've created one "release" for each of the projects around FTS. Be sure to look on the right side at the various releases in order to see the various projects.
Next, you can get started with the basics by reading these entries on my blog:

Lesson 0 - Getting the Bits to do Full Text Searching in SQL Server 2005
Lesson 1 - The Catalog
Lesson 2 - The Indexes
Lesson 3 - Using SQL
Lesson 4 - Valid Data Types
Lesson 5 - Advanced Searching


After that you'll be ready for some advanced topics.

Can you hear me now? Checking to see if FTS is installed.
Exploring SQL Servers FullTextCatalogProperty Function
Using the ObjectPropertyEx Function
Using FORMSOF in SQL Server Full Text Searching
Creating Custom Thesaurus Entries in SQL Server 2005 and 2008 Full Text Search
Creating and Customizing Noise Words in SQL Server 2005 Full Text Search
Creating and Customizing Noise Words / StopWords in SQL Server 2008 Full Text Search
Advanced Queries for Using SQL Server 2008 Full Text Search StopWords / StopLists

You can also get short training videos that I created at:
JumpStartTV.com/RobertCain