August 17, 2011 at 1:05 pm
SJanki (8/17/2011)
Hi Kraig F,I have the binary images of PDFs in a table stored in varbinary(max). I am using Full Text Search. When I search for 44 f(2)(E), it returns all the documents having-->
44 OR 44 F OR 44 OR 44F(2)(A) OR 44 E....
What do I need to do to make it return only the document having the exact phrase
44 f(2)(E)?
Sorry, for deviating from the original (Kazim's) questions.
Not a problem. Sounds like it's doing a fuzzy match. () are word breaks to the editor, so you're actually ending up doing a phrase search (if I remember correctly). I'd have to do a lot of digging into full text semantics for that, it's been a while since I got that deep into the details.
The fact that there's a space in the searched component means it's a multi-word search, and thus isn't directly indexed.
Now, integrate that with the binary of the pdf component and... errr... ummm... honestly I don't remember, and I won't have the time to do that kind of research for a few days at least. Hopefully someone else will see this and get involved. 🙂
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 18, 2011 at 9:23 am
Hmm, I think I need to use the AND condition with Contains, but AND is not giving expected results whereas OR condition works fine.
~ Janki
August 18, 2011 at 1:53 pm
Folks
I'll tend to drift away from the actual subject here, that is from Full text and search pattern.
When I run a select * from on the attached table with the attached data, it takes about 15 seconds to return the data set, if I exclude SSOMapping, it takes no time to return the data. Why is that so? Is it because of SSOMapping being nvarchar(max) and stored across different data pages?
I am attaching the table structure as well as the sample data (Thank you Red Gate!) I have populated.
Regards,
Kazim Raza
August 19, 2011 at 11:35 am
Guys, no one??
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply