No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Answered1Votes
How implement one unary operator NOT in FTS?
Hi all. This CONTAINS (mycolumn, 'NOT "phrase_to_search_for" ' ) is not valid and doesn't work in FTS. How to implement such in ...2 Replies | 105 Views | Yatajga - Friday, June 28, 2013 3:11 PM | Last Reply Yatajga - Sunday, June 30, 2013 12:01 PM -
Unanswered0Votes
Issue how Thesaurus words are treated between SQL Server 2008 R2 and 2012
Hi, Maybe you could help me to understand how Thesaurus 'expansion set' works. Expansion set ...1 Replies | 80 Views | Kestutis Dziautas - Friday, June 28, 2013 1:46 PM | Last Reply Allen Li - MSFT - Sunday, June 30, 2013 6:42 AM -
Unanswered0Votes
FULL TEXT CATALOG Population not finishes
Hi, Upgraded from SQL 2000 to 2008 R2 and full text catalog starts from scratch, populating catalog continues and not completed. It's already 1.3TB in size. How to identify ...4 Replies | 135 Views | KarthikNila - Wednesday, June 26, 2013 8:24 PM | Last Reply KarthikNila - Saturday, June 29, 2013 7:02 PM -
Unanswered0Votes
SQL Server 2012 FullText Missing records
Full text is missing indexing records on SQL Server 2012 with even simple contains query, when searched with 'ARM' keyword.While all other records are searchable issue is only with 'ARM' ...1 Replies | 74 Views | izi0 - Tuesday, June 25, 2013 1:56 PM | Last Reply Allen Li - MSFT - Wednesday, June 26, 2013 9:31 AM -
Unanswered0Votes
Stop Words Blocking Results
I've been developing code to convert a Google-style search query to a full-text-search query. For example, it would conver "red car" to "(FORMSOF(INFLECTIONAL, ...7 Replies | 3725 Views | Jonathan Wood - Sunday, June 19, 2011 3:48 PM | Last Reply Matthias76 - Tuesday, June 25, 2013 11:17 AM -
Answered0Votes
SQL Server Full-Text Search: combining proximity term and thesaurus
Scenario I am developing a full-text search over a products table. The full-text indexed field of th table contains a ...1 Replies | 101 Views | Alberto De Caro - Wednesday, June 19, 2013 12:32 PM | Last Reply Allen Li - MSFT - Friday, June 21, 2013 2:49 AM -
Answered1Votes
Mixed results with SQL Search
I have a simple SQL procedure which I submit from a vb.net program, but the search does not give me the right results. I can't figure out what's wrong with it. From the vb.net program, I ...6 Replies | 257 Views | Gina Becker - Thursday, June 13, 2013 8:26 PM | Last Reply Gina Becker - Friday, June 14, 2013 4:11 PM -
Answered0Votes
Installing SQL Server 2008
When trying to install SQL server 2008 in my computer( Windows 7,32 bits), after a couple of steps, arriving in "support files of instalation" the setup tool just dissapears and does not ...1 Replies | 252 Views | CaiqueRibeiro - Tuesday, June 11, 2013 2:16 PM | Last Reply Shanoof Basheer - Tuesday, June 11, 2013 2:21 PM -
Answered1Votes
MS SQL SERVER DATABASE HOSTING ?
Hi All Please let me know what is ms sql server database hosting ? Please provide related articles how to configure the ms sql ...5 Replies | 339 Views | Kiran.Batthula - Thursday, June 06, 2013 8:15 AM | Last Reply Kiran.Batthula - Monday, June 10, 2013 11:17 AM -
Proposed0Votes
Tips of improving the full text search performance with massive data and complicated queries
Hi All: I am just wondering if there is anyone who would like to share with us the experiences of those practices that improve the FTS performance with massive dataset and very ...6 Replies | 353 Views | JohnnyKahWang - Wednesday, June 05, 2013 2:07 PM | Last Reply JohnnyKahWang - Monday, June 10, 2013 12:25 AM -
Answered0Votes
In operator in Criteria using value from a form
Hi, I have a form have a text box (AccNOB) where i store some data with , separator. It look like this : 11200,11400,11700,20200....and so on ...3 Replies | 265 Views | AshishKumar1200 - Friday, June 07, 2013 10:12 AM | Last Reply SQLWork - Friday, June 07, 2013 9:53 PM -
Answered0Votes
Txt fulltext filter - which UNICODE encodings are supported
Hello, I have a varbinary(max) column C in which I store content of text file. On this column I have fulltext index. Which encodings of text files are supported in fulltext ...1 Replies | 201 Views | Jan Vávra - Friday, June 07, 2013 11:37 AM | Last Reply SQLWork - Friday, June 07, 2013 1:00 PM -
Answered0Votes
Is SQL Server 2012 the last generation shipped with Full Text Search
There is saying MS will remove FTS from next generation of SQL Server shipment. Well i think the SQL Server has big problem on the performance (speed in particular) on massive level text search and ...2 Replies | 429 Views | JohnnyKahWang - Sunday, May 26, 2013 9:08 AM | Last Reply JohnnyKahWang - Wednesday, June 05, 2013 2:07 PM -
Answered0Votes
Full-text parsing question
Why does the following: select * from sys.dm_fts_parser(Nchar(34) +'5 CAD' + Nchar(34), 0, null, 0) results special_term display_term Exact Match 5 ...4 Replies | 242 Views | HSaid2 - Tuesday, June 04, 2013 12:49 AM | Last Reply HSaid2 - Tuesday, June 04, 2013 9:13 PM -
Answered0Votes
\n \r in Full Text Index
I am not a SQL Server expert by any means so bear with me. I am trying to add full text search to a column in my table. It seems to work ok, but it does not filter out or ...4 Replies | 354 Views | jbuzz - Tuesday, May 21, 2013 5:15 PM | Last Reply jbuzz - Tuesday, June 04, 2013 6:30 PM -
Proposed0Votes
Query to gather counts for records that have planned execution and actual execution dates
= -14 and DATEDIFF(d,getdate(), tc_plan_scheduling_date)3 Replies | 259 Views | Portfoliodude - Saturday, June 01, 2013 4:36 PM | Last Reply Allen Li - MSFT - Tuesday, June 04, 2013 9:46 AM -
Answered0Votes
Full Text Search - thesaurus file is not loaded / working
I am trying to follow the tutorial - http://msdn.microsoft.com/en-us/library/ms142491.aspx for setting up a thesaurus file when querying Full Text ...1 Replies | 225 Views | rails5 - Monday, June 03, 2013 8:50 AM | Last Reply Allen Li - MSFT - Tuesday, June 04, 2013 6:58 AM -
Unanswered0Votes
Full text word separators
I am using FullText Search in SQL Server 2005 and now I just migrate to SQL Server 2012. Now in SQL 2012 I have some problems with word separators. For example, for a word ...4 Replies | 308 Views | Rui F. Oliveira - Friday, May 31, 2013 2:14 PM | Last Reply SQLWork - Monday, June 03, 2013 5:07 PM -
Answered2Votes
Leading zeroes ignored in freetext search mssql 2010
I have a free text search index on a column called 'search'. When I run the query: Select top 10 * from XXX where contains(search,'0045') This gives correct ...5 Replies | 306 Views | wtnind - Monday, June 03, 2013 10:33 AM | Last Reply wtnind - Monday, June 03, 2013 1:22 PM -
Answered0Votes
Problem with HAVING/COUNT
1 But I do not think this is correct. Any help? thanks2 Replies | 232 Views | my_drive - Thursday, May 30, 2013 5:27 PM | Last Reply Olaf Helper - Thursday, May 30, 2013 5:34 PM - Items 1 to 20 of 861 Next ›