Tag Archives: full text search

Setup Full-Text using T-SQL–#SQLNewBlogger

Posted on June 30, 2021 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I wrote a previous post on how to set up full-text searching (FTS) and indexes in SSMS. This post … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Setup Full-Text using T-SQL–#SQLNewBlogger

Setting up a Full Text Index–#SQLNewBlogger

Posted on June 9, 2021 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a question recently on  Full Text Search. I knew the answer, but to test some code, I … Continue reading →

Posted in Blog | Tagged , , | 3 Comments

Killing FTS

Posted on June 24, 2019 by way0utwest

In almost every application that I’ve helped build, we had a need to perform textual searches of fields. Sometimes this was in short fields, like names, where we usually needed some sort of wildcard search to let users find information. … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Killing FTS

Missing Full Text Extensions in Express

Posted on February 23, 2015 by way0utwest

I was tasked recently with removing the full text indexes in Adventureworks for a demo. The full text indexes were causing a few extra items to appear in a SQL Compare demo and weren’t needed. The individual that had set … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Missing Full Text Extensions in Express