Lab Sql

I'm getting my feet wet with handling a load of Office and PDF documents with SQL Server 2012&#… Read more Sql Server 2012 - Fulltext Search On Top Of A Filetable - Pdf Not Being Searched

I have an asp.net web page used to search for company names in our database using FTS. They enter … Read more Sql Full-text-search Returns No Results When Any Noise Words Are In Search String

I am working on a django application with sqlite3 database, that has a fixed database content. By f… Read more How To Use Full-text Search In Sqlite3 Database In Django?

I would like to be able to search every word so I have cleared the stop word list. Than I have rebu… Read more Full Text Search Does Not Work If Stop Word Is Included Even Though Stop Word List Is Empty

How can I copy the value of a field, but only its numbers? I am creating a computed column for full… Read more Sql Server - Filter Field Contents To Numbers Only

I have the following query where I would like to return two result sets. One being the results as a… Read more Return Two Result Sets When Using With Tempresults As

I do not understand why following Query1 and Query2 don't return similar result sets. Samples Q… Read more Sql Server Full-text Search With Prefix And Noise Word

I'm trying to understand the performance of an SQL Server 2008 full-text query I am constructin… Read more Sql Server Full Text Query Across Multiple Tables - Why So Slow?

I am writing a search application specifically for music playlists. The genre and file format diffe… Read more How To Structure Data For Searchability

I have a stored procedure that searches a table which has about 200000+ rows with full text FREETEX… Read more Sql Server Full Text Search Very Slow

I'm basically trying to create a search to find articles (or articles from an author). I've… Read more Mysql Join And Match/against Search Fail

When using the LIKE/ILIKE operator in PostgreSQL 9 is it possible to match word boundaries without … Read more Ilike Match Word Boundaries Postgresql 9

My question is about using fulltext.As I know like queries which begin with % never use index : SEL… Read more Full Text Search Vs Like

I have an Indexed View with two columns, a primary key char and a field for full-text indexing varc… Read more Sql Server 2005 Fts Unexpected Results

Can someone explain this to me? I have two queries below with their results. query: select * from … Read more Sql Contains Question

Here's my quandary. I have a variable that contains a paragraph of text, and I have a column fu… Read more Optimizing An Sql Search Using A Column For Keywords And A Variable As The Text To Be Searched

Lets assume we have a full text indexed table with those records: blabla bla bla 101010,65 blabla b… Read more Sql Server 2008 - Fulltext Rounding Money Values?

I have an Sql Server 2016 database with full text indexes defined on 4 columns, each configured for… Read more Full-text Search Stemming Not Returning Consistent Results In Different Languages

Now that SQL Server 2008 has full text search built in. I'm looking to use it to power my websi… Read more How Do You Do Full Text Search (fts) With Linq To Ado.net Entity Framework?

I'm running Sql Server 2008 R2 and I need to enable Full-Text search on a view with a inner joi… Read more Enable Full-text Search On View With Inner Join