No announcements
Found 1408851 threads
-
0 VotesFull Text Index Not Working
An index on a text column will help as long as you can provide the starting characters.Answered | 3 Replies | 3405 Views | Created by David92595 - Wednesday, May 9, 2012 12:03 AM | Last reply by Ajith Krishnan - Thursday, May 10, 2012 4:58 AM
-
2 Votes
View - Define full text index
The error message seems to be clear, so if you have text column, try converting it to varchar(max) first.Answered | 3 Replies | 1462 Views | Created by Nadim2522 - Wednesday, April 24, 2013 6:38 AM | Last reply by Naomi N - Wednesday, April 24, 2013 1:06 PM -
2 Votes
Updating full text indexes
Change tracking was enabled in SQL 2000 but you would have to configure your full-text indexes for it.Answered | 3 Replies | 10151 Views | Created by wakthar - Thursday, January 22, 2009 9:28 PM | Last reply by wakthar - Tuesday, January 27, 2009 4:04 PM -
0 Votes
Full Text Index
In addition, there are some recommendations for you maintaining full text index as follows.Answered | 5 Replies | 1468 Views | Created by Vinod Mallolu - Friday, April 24, 2015 10:12 AM | Last reply by Lydia Zhang - Thursday, April 30, 2015 2:24 AM -
1 Votes
SQL full text indexing / indexed view?
Hello, For a full text index a unique index as reference is required, so if there is a unique index on the view then you can ...Answered | 2 Replies | 2069 Views | Created by scott_m - Wednesday, September 25, 2013 2:32 PM | Last reply by scott_m - Saturday, November 2, 2013 8:58 PM -
0 Votes
Using full text indexing
Indeed, in full-text searching a wildcard like % is not allowed in the beginning of the search text.Answered | 6 Replies | 5380 Views | Created by MrFlinstone - Monday, April 11, 2011 9:06 AM | Last reply by Steven Wang - Shangzhou - Tuesday, April 12, 2011 9:09 AM -
0 Votes
Full-text index is not being used
I asked why the query with CONTAINS (which should use the full-text index) has higher query cost percentage than when using LIKE (which I know that it ...Answered | 5 Replies | 2259 Views | Created by Butmah - Tuesday, March 18, 2014 7:32 AM | Last reply by SQLWork - Friday, March 21, 2014 3:51 PM -
0 Votes
Maintaining a Full Text index
Hello All, I am working on Full Text indexes maintenance.Answered | 3 Replies | 1273 Views | Created by krishh.kk - Wednesday, July 6, 2016 4:00 PM | Last reply by Olaf Helper - Wednesday, July 6, 2016 5:06 PM -
0 Votes
Checking ampersand in full-text index
i.e. leaving the fulltext index as it is but allow certain characters such as & and etc.Answered | 6 Replies | 7949 Views | Created by dvdavid2001 - Wednesday, June 29, 2011 7:26 AM | Last reply by dvdavid2001 - Sunday, July 10, 2011 10:52 AM -
0 Votes
Problem in full-text index SQL Server 2005 Express Edition
But, the full-text engine also depends on the full-text key which is either the Primary Key or unique index key on the base table.Answered | 7 Replies | 6226 Views | Created by dvdavid2001 - Saturday, November 28, 2009 6:47 AM | Last reply by dvdavid2001 - Sunday, November 29, 2009 2:30 PM -
0 Votes
Using full text index of an underlying table on a view
Hi Ales, It is not possible to create a full-text index on a table and then use full text search on a VIEW ,because there is no ...Answered | 2 Replies | 3113 Views | Created by Ales Sturala CZE - Sunday, October 30, 2011 2:04 PM | Last reply by Ales Sturala CZE - Tuesday, November 1, 2011 8:32 AM -
1 Votes
Keyword "DUDIT" not searchable in a full text index
Problem solved.Answered | 8 Replies | 3950 Views | Created by Lagrange Romain - Friday, June 25, 2010 12:52 PM | Last reply by Lagrange Romain - Monday, June 28, 2010 4:09 PM -
0 Votes
SQL Server Full Text Index with Joins
I am sure Full Text Index shall be faster as compared to above operators.Answered | 4 Replies | 1566 Views | Created by contacthirenparikh - Tuesday, March 13, 2018 2:10 PM | Last reply by contacthirenparikh - Wednesday, March 21, 2018 7:40 AM -
0 Votes
Full Text indexing search issue
I doubt that projects is a noise word, but it is possible that very frequent in your text.Answered | 1 Replies | 3149 Views | Created by Johnson Samuel - Friday, October 7, 2011 5:23 AM | Last reply by Kalman Toth - Friday, October 7, 2011 11:01 AM -
0 Votes
Full-Text Index problem on SQL 2008 EE
Olaf, The index was up to date.Answered | 5 Replies | 1370 Views | Created by Tyler Darkow - Wednesday, January 8, 2014 8:01 PM | Last reply by Tyler Darkow - Thursday, January 9, 2014 3:12 PM -
0 Votes
Tempdb Use full text indexing
For a new database, the full-text catalog is now a virtual object that does not belong to any filegroup; it is merely a logical concept that refers to a group of the ...Answered | 2 Replies | 1472 Views | Created by anaylor01 - Sunday, August 28, 2016 10:19 PM | Last reply by S_NO - Monday, August 29, 2016 1:14 AM -
1 Votes
full text index
Would you please check-out What Can I Do with Full-Text Search?Answered | 1 Replies | 2192 Views | Created by Katrina BX - Saturday, October 20, 2012 5:06 AM | Last reply by Ahmed Ibrahim - MSFT - Saturday, October 20, 2012 5:17 AM -
0 Votes
SQL DB Full-Text Indexing
I just wanted to be sure that SCOM itself does not require Full-Text Indexing to be turned on...Answered | 2 Replies | 3536 Views | Created by John _ PL - Friday, May 14, 2010 5:15 PM | Last reply by John _ PL - Friday, May 14, 2010 6:43 PM -
1 Votes
Full text index in Azure SQL DB
Pause populating the full-text index during load helps crawl to pause and improves the load performance.Answered | 3 Replies | 1190 Views | Created by NewBeeMS - Thursday, June 4, 2015 3:59 PM | Last reply by NewBeeMS - Friday, June 5, 2015 1:20 PM -
0 Votes
Full Text Index Query - SQL Server 2005
Hi I think you need 3 columns other than the primary key and other columns you need: 1. the nvarchar(max) for the original HTML ...Answered | 6 Replies | 6155 Views | Created by NandipMakwana - Tuesday, March 22, 2011 1:10 PM | Last reply by Steven Wang - Shangzhou - Wednesday, March 23, 2011 6:05 AM - Items 1 to 20 of 1408851 Next ›
No announcements
