No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
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 ... -
Unanswered0VotesFull Text Search combining FREETEXTTABLE with ranking and CONTAINS
I am trying to develop a search query that will give my users the most relevant results first but also specifically define the best way to find results in specific columns. I've come up with the query ... - Items 1 to 20 of 855 Next ›


