No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Unanswered0VotesSQL 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 ... -
Answered1VotesMixed 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 ... -
Answered0VotesInstalling 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 ... -
Answered1VotesMS 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 ... -
Proposed0VotesTips 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 ... -
Answered0VotesIn 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 ... -
Answered0VotesTxt 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 ... -
Answered0VotesIs 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 ... -
Answered0VotesFull-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 ... -
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 ... -
Proposed0VotesQuery to gather counts for records that have planned execution and actual execution dates
= -14 and DATEDIFF(d,getdate(), tc_plan_scheduling_date) -
Answered0VotesFull 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 ... -
Unanswered0VotesFull 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 ... -
Answered2VotesLeading 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 ... -
Answered0VotesProblem with HAVING/COUNT
1 But I do not think this is correct. Any help? thanks -
Answered0VotesGetting counts for number of executions for field per day for weekly history
I have a database that I am accessing with SQL through ODC connection from Excel. I have a specific field that is attached to some testing transactions that I need to track. I need to know ... -
Answered1VotesPRIMARY key column order vs WHERE condition column order
Assume a table of Foo with primary key of A as int, B as char(6), C as int, D as int If I build a TSQL statement with a WHERE condition of B, C, A is the query ... -
Answered0VotesReturning sub string of query using FT search
Hello: I have created a FT search index on a column of table 'A', which contains large amounts of document data. Using CONTAINS, I am able to search this column to filter the result ... -
Discussion0Votesms sql server 2008 full text search
Hi, Can anyone please tell me what is going wrong or what am i doing wrong in the following: I created a full text catalog to be able to do FTS for a test ... -
Unanswered0Votes[FullText] Indexer seems to cut up some words at accent position
I have a full text catalog defined on 2 VARCHAR columns of a single table. It works well except for a few words where indexation seems to cut the term where an accent is found. It doesn't do it for ... - Items 1 to 20 of 856 Next ›


