Tag Archives: full text search

Setup Full-Text using T-SQL–#SQLNewBlogger

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 , , | Leave a comment

Setting up a Full Text Index–#SQLNewBlogger

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

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

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