No announcements
-
0 VotesHow 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 ...Unanswered | 1 Replies | 375 Views | Created by Josh Repp - Tuesday, July 24, 2018 7:54 PM | Last reply by Kevin Urquhart - Wednesday, October 17, 2018 12:19 PM
-
0 Votes
Database with Full-Text Catalog Restore
Hi. I seem to be missing the full-text files on my source (2005) database "myDB"after I backed it up and restored it to a couple different destinations for test ... -
1 Votes
Check Available Rooms
I have the following table in Sql Server 2017, Booking(Id, CustomerId, RoomId, ReservationDate, CheckInDate, CheckOutDate, Status, AccountId) Room(Id, ...Answered | 3 Replies | 206 Views | Created by RJ Evangelista - Saturday, September 29, 2018 9:36 PM | Last reply by Visakh16 - Sunday, September 30, 2018 8:20 AM -
0 Votes
Fulltext Search including brackets and full stop
I am trying to implement a solution that if for instance the database holds the following text "Carbon Dioxide 0.2M (2mml)" a user should be able to ...Unanswered | 1 Replies | 128 Views | Created by farahijahromi - Tuesday, September 25, 2018 3:49 AM | Last reply by Olaf Helper - Tuesday, September 25, 2018 5:48 AM -
0 Votes
How to avoid doing a full text query before the new row inserted in the table is indexed?
I created a full text catalog from a table for doing some full text queries, and in the moment just after insert a new row in the table, if I do a full text query, the query returns nothing ...Unanswered | 5 Replies | 355 Views | Created by Rui Frazão Oliveira - Monday, September 17, 2018 3:30 PM | Last reply by Hilary Cotter - Monday, September 17, 2018 8:00 PM -
0 Votes
Dynamically Month should change based on Current
Hi, We have a requirement as below any help in this regard will be very helpful We need to calculate Month ...Discussion | 5 Replies | 286 Views | Created by Amit_Jha1 - Tuesday, August 28, 2018 8:39 AM | Last reply by Visakh16 - Tuesday, August 28, 2018 2:55 PM -
0 Votes
Sql Sever 2017 Certification
Hi I dont see Sql Sever 2017 Certification yet, can any one let me know when does this will be ...Proposed | 1 Replies | 291 Views | Created by RANJITH K - Thursday, August 23, 2018 8:15 PM | Last reply by Teige Gao - Friday, August 24, 2018 1:19 AM -
0 Votes
Full text index Error '0x8004fd0a: Occurrence counter overflow, document is not indexed.' occurred during full-text index population for table or indexed view
We have attachments table and a full-text index. The index was worked properly in 2008R2 SQL server. But Recently we upgraded to 2012 sp4 and couple new columns are added to the attachment table. ... -
0 Votes
sqlcommand 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 | 336 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 ...Answered | 10 Replies | 416 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 | 355 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 | 9848 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
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 | 360 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 | 474 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 | 424 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 | 501 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 | 460 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 ... - Items 1 to 20 of 1326 Next ›
No announcements
