SQL Server Full Text Searching

UPDATED RELEASE: SQL Server 2005 2008 FTS Presentation Slide Deck (Jun 06, 2008)

Sat, 03 Oct 2009 04:14:05 GMT

UPDATED WIKI: Home

arcanecode — Sat, 31 Jan 2009 05:50:57 GMT

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

UPDATED WIKI: Home

arcanecode — Sat, 31 Jan 2009 05:33:27 GMT

UPDATED RELEASE: SQL Server 2005 2008 FTS Presentation Slide Deck (Jun 06, 2008)

Sat, 31 Jan 2009 05:30:32 GMT

UPDATED RELEASE: SQL Server 2005 2008 FTS Presentation Slide Deck (Jun 06, 2008)

Tue, 19 Aug 2008 18:01:13 GMT

UPDATED WIKI: Home

arcanecode — Tue, 19 Aug 2008 17:56:44 GMT

On August 19th, 2008 I am presenting "Getting Started with SQL Server 2005/2008" at the TechMixer University conference that is taking place in Birmingham Alabama. This post will have all the links relavent to my talk.

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

UPDATED RELEASE: WPF Binding to SQL Server Full Text Search Demo (Jun 06, 2008)

Sat, 07 Jun 2008 06:34:07 GMT

RELEASED: WPF Binding to SQL Server Full Text Search Demo (Jun 06, 2008)

Sat, 07 Jun 2008 06:34:07 GMT

UPDATED RELEASE: WPF Binding to SQL Server Full Text Search Demo (Jun 06, 2008)

Sat, 07 Jun 2008 06:26:35 GMT

UPDATED RELEASE: WPF Binding to SQL Server Full Text Search Demo (Jun 06, 2008)

Sat, 07 Jun 2008 06:26:00 GMT

CREATED RELEASE: WPF Binding to SQL Server Full Text Search Demo (Jun 06, 2008)

Sat, 07 Jun 2008 06:25:30 GMT

RELEASED: SQL Server 2005 2008 FTS Presentation Slide Deck (Jun 06, 2008)

Sat, 07 Jun 2008 06:23:50 GMT

UPDATED RELEASE: SQL Server 2005 2008 FTS Presentation Slide Deck (Jun 06, 2008)

Sat, 07 Jun 2008 06:23:50 GMT

CREATED RELEASE: SQL Server 2005 2008 FTS Presentation Slide Deck (Jun 06, 2008)

Sat, 07 Jun 2008 06:23:25 GMT

RELEASED: SQL Server 2005 Full Text Search Demo for SSMS (Jun 06, 2008)

Sat, 07 Jun 2008 05:54:54 GMT

UPDATED RELEASE: SQL Server 2005 Full Text Search Demo for SSMS (Jun 06, 2008)

Sat, 07 Jun 2008 05:54:54 GMT

UPDATED WIKI: Home

arcanecode — Sat, 07 Jun 2008 05:53:00 GMT

On June 7th, 2008 I am presenting "Getting Started with SQL Server 2005/2008" at the InBetween SQL Saturday conference that is taking place between the two weeks of Microsoft TechEd. This post will have all the links relavent to my talk.

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

UPDATED WIKI: Home

arcanecode — Sat, 07 Jun 2008 05:52:39 GMT

On June 7th, 2008 I am presenting "Getting Started with SQL Server 2005/2008" at the InBetween SQL Saturday conference that is taking place between the two weeks of Microsoft TechEd. This post will have all the links relavent to my talk.

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

UPDATED RELEASE: SQL Server 2008 StopLists StopWords Demo (Jun 06, 2008)

Sat, 07 Jun 2008 05:35:13 GMT

RELEASED: SQL Server 2008 StopLists StopWords Demo (Jun 06, 2008)

Sat, 07 Jun 2008 05:35:13 GMT