No announcements
-
0 Votessqlcommand question
text"'". But if I have for example 5 columns to define and in case the user can also NOT enter any value in one or more in the 5, the situation becomes more ...Answered | 6 Replies | 80 Views | Created by jerrylinkinpark - Wednesday, August 8, 2018 7:30 AM | Last reply by Visakh16 - Wednesday, August 8, 2018 1:32 PM
-
0 Votes
Which Microsoft SQL Server version don't need to create full text catalog and full text index?
Hi, I want to use the full text functionality. Without create full text index. If it's possible. In which Microsoft SQL Server version we don't need to create ...Proposed | 10 Replies | 165 Views | Created by vj529992 - Tuesday, August 7, 2018 5:26 AM | Last reply by willson yuan - Tuesday, August 7, 2018 7:35 AM -
0 Votes
Which Microsoft SQL Server version don't need to create full text catalog and full text index?
Hi, I want to use the full text functionality. Without create full text index. If it's possible. In which Microsoft SQL Server ...Discussion | 1 Replies | 106 Views | Created by vj529992 - Tuesday, August 7, 2018 5:27 AM | Last reply by Visakh16 - Tuesday, August 7, 2018 5:46 AM -
3 Votes
Adobe PDF IFilter for document searches does not work
I am new to full text indexing of documents but I know enough to get the files into the database and apply indexing and searches because I got it to work for Word (.doc) files. ...Proposed | 6 Replies | 9320 Views | Created by digger8 - Thursday, April 4, 2013 4:40 PM | Last reply by Manuela Re - Thursday, July 26, 2018 9:19 PM -
0 Votes
How to find replace characters like à  in a column
I have recently imported a database from a .xlsx file and I've found that several columns have character strings in them like 'ö' where I am expecting to expect to see 'ö'. I'm ... -
0 Votes
Which query return huge data size and taken long time
I want to check which query return huge data in size and which query taken long time on execution?Unanswered | 1 Replies | 107 Views | Created by Calvin12345 - Friday, July 20, 2018 10:27 AM | Last reply by Olaf Helper - Friday, July 20, 2018 12:01 PM -
1 Votes
Link WITH Subquery to main query
Hi I'm trying to link two tables (Account and Address), but only wanting to get the most recent Shipping Address of each account (the address table holds the ...Answered | 1 Replies | 191 Views | Created by ROSS_AS - Friday, July 6, 2018 1:04 AM | Last reply by Ousama EL HOR - Monday, July 16, 2018 3:30 PM -
0 Votes
SQL Server Json data Query search performance hit
When we tried to search Json property data in SQL server , response time is high even after creating indexes on top of Json column. What has to be done for improving the ... -
0 Votes
Link Tag Items to TestCaseId in TFS 2017
I would like to create a report that links the Tag Items to their corresponding Test Cases in TFS 2017, that is running on SQLServer 2014 with SSRS 2014. However, I am unable to find the ...Unanswered | 2 Replies | 175 Views | Created by yummybehr - Tuesday, July 10, 2018 12:40 AM | Last reply by Visakh16 - Tuesday, July 10, 2018 6:05 AM -
0 Votes
Contains Predicate Behavior in Full-Text search
Hi Team, We are using Contains predicate along with full text catalog. SELECT * FROM sys.dm_fts_parser(N'"CM 2.1.7 Change cage ... -
0 Votes
Restoring a database by impersonating the sysadmin privilege
Dear All, In our environment we are getting frequent request for DB restoration, hence we want to automate this process and handover to our application team with minimal privilege. ...Unanswered | 1 Replies | 250 Views | Created by Arup.mca - Friday, May 25, 2018 12:16 PM | Last reply by Mohsin_A_Khan - Saturday, June 9, 2018 3:00 PM -
0 Votes
Search strings with special characters
I do have an entry in my database which is ABC-28 and sometimes ABCD/45, how do i find them if the user just type in just only the alphanumeric characters like ABC28 or ABCD45. The special characters ...Answered | 1 Replies | 224 Views | Created by Dikong42 - Thursday, June 7, 2018 1:24 PM | Last reply by Ashish Kumar Tiwari - Thursday, June 7, 2018 3:15 PM -
0 Votes
CONTAINSTABLE difference results for mssql 2008 r2 vs. Azure SQL 12.0
Hello! I faced with some strange behavior related with how fulltextsearch works. I have a table tblAccount with account named "S&P&S ... -
0 Votes
Calculate Months Since a certain Activity given it's ActualDate
Hello i have recorded an activity in SQL that happened last year, now i want to add a field to calculate how many months since that activity, i know the actual date of the activity. ...Answered | 1 Replies | 236 Views | Created by Rabelani Netshifhire - Tuesday, June 5, 2018 1:43 PM | Last reply by Rabelani Netshifhire - Tuesday, June 5, 2018 3:32 PM -
0 Votes
using full text search on filetable with custom file extensions
Hello, I got application that is saving data to custom file type with extension *.abc. I made a filetable, fulltext catalog, index on that table and I want to use ... -
1 Votes
Contains Predicate behavior
Hi Team, I am using Contains predicate along with full text catalog. SELECT * FROM sys.dm_fts_parser(N'"CM 2.1.7 Change cage & rack - Ger"', 1033, ...Unanswered | 1 Replies | 311 Views | Created by Rushyendra.P - Thursday, May 3, 2018 2:55 PM | Last reply by Rushyendra.P - Wednesday, May 23, 2018 6:40 AM -
0 Votes
How to search this kind of data efficiently?
Nowadays we have database and file system to store the data. If we store some json object in database, how can we search the json string efficiently in sql server? I know if we export the data to .NET ...Unanswered | 3 Replies | 318 Views | Created by John Smith 88 - Friday, April 27, 2018 12:01 PM | Last reply by Visakh16 - Friday, April 27, 2018 1:43 PM -
0 Votes
Search in the article using keyword
dear friends, I have a question, can I search in the article ? I have a keyword 1 "Andi" and keyword 2 "Sudarman" how can I ...Unanswered | 7 Replies | 319 Views | Created by steve_henry - Tuesday, April 17, 2018 7:11 AM | Last reply by Visakh16 - Tuesday, April 17, 2018 8:27 AM -
0 Votes
Search in the article using keyword without using Like (another faster way)
dear friends, I have a question, can I search in the article ? I have a keyword 1 "Andi" and keyword 2 ...Unanswered | 2 Replies | 295 Views | Created by steve_henry - Tuesday, April 17, 2018 7:29 AM | Last reply by Soumen Barua - Tuesday, April 17, 2018 8:10 AM -
0 Votes
Full Text Search always get an error after upload data from excel
Hy Friends I have a problem, why my SQL Got an error after I finished upload the data to SQL Server from excel when I try to search using Full text, the SQL ... - Items 1 to 20 of 1319 Next ›
No announcements
