No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Unanswered0Votes
i want a query - Which is larger than a date and a time, but time only on the first query is. (where date > '1391/11/02' and time > '10:21' )
'1391/11/02' and time > '10:21' ) please see picture0 Replies | 47 Views | mohammad rabiyi - 1 hour 39 minutes ago -
Answered1Votes
problem with spaces in full text search using contanis....
declare @keyword = 'Phil stein corporate photography fine art' set @keyword = replace (@keyword,' ',' near ') print @keyword = Phil near stein near corporate near ...1 Replies | 84 Views | Queriessqlserver - Friday, July 05, 2013 10:21 AM | Last Reply Latheesh NK - Friday, July 05, 2013 10:52 AM -
Unanswered0Votes
sql server connection issue
Dear Concern, This is to inform you that i got below issue in executing one process through application.However it got corrected automatically.Can somebody tell ...0 Replies | 36 Views | Trehan11 - Friday, July 05, 2013 9:24 AM -
Unanswered0Votes
Microsoft SQL Server 2012 version
I am looking for an online course under Microsoft SQL Server 2012 that is self paced. I am also looking for training that has screen demonstrations and simulation exercises, not just videos to ...0 Replies | 53 Views | BriJohn - Thursday, July 04, 2013 1:06 AM -
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 | 147 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 | 129 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 | 170 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 | 104 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 | 3762 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 | 121 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 | 283 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 | 288 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 | 382 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 | 391 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 | 295 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 | 240 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 | 481 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 | 277 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 | 405 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 | 297 Views | Portfoliodude - Saturday, June 01, 2013 4:36 PM | Last Reply Allen Li - MSFT - Tuesday, June 04, 2013 9:46 AM - Items 1 to 20 of 865 Next ›