Tag Info

New answers tagged

2

Your query actually needs to use two properties of the CONTAINSTABLE function- <maximum distance> and <match_order>. Using CONTAINSTABLE(OpinionDocuments, HTML, 'NEAR((Foo, bar), 0, TRUE)') AS KEY_TBL Specifies to find "Foo" near "Bar" with 0 search objects between (<maximum distance> ", 0,") and in the order specified ...


2

The short answer to your question is that query expansion enhances the original search term by adding extra, relevant, information to the search term. Mis-quoting an example from Derek's link: An example could be searching for books by Georges Simenon about Maigret, when a user is not sure how to spell “Maigret”. A search for “Megre and the reluctant ...


2

CONTAINS is used for full-text searching, and can search for: for a word or phrase the prefix of a word or phrase a word near another word a word inflectionally generated from another word, such as spoon and spooning synonyms Perhaps you should use: DECLARE @String2 NVARCHAR(20) = '"SomeName''%"'; SELECT * FROM dbo.NamesTable NT WHERE NT.Name LIKE ...


1

Rather than try to guess, you should download Percona Tools. You should use the tool pt-duplicate-key-checker. It will compare all the indexes for you and give your the ALTER TABLE commands to drop the ones you do not need and still maintain fully compliance with all your index search needs. Here is the code to do it: ...



Top 50 recent answers are included