No announcements
Found 889352 threads
-
2 VotesView - Define full text index
What is the structure of your view?Answered | 3 Replies | 1623 Views | Created by Nadim2522 - Wednesday, April 24, 2013 6:38 AM | Last reply by Naomi N - Wednesday, April 24, 2013 1:06 PM
-
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 ...Answered | 2 Replies | 2265 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 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 | 3262 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 -
0 Votes
Full Text Index
please could you suggest the best practices for maintaining a full text index please?Answered | 5 Replies | 1653 Views | Created by Vinod Mallolu - Friday, April 24, 2015 10:12 AM | Last reply by Lydia Zhang - Thursday, April 30, 2015 2:24 AM -
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 | 5576 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 Not Working
Maybe you are already aware of this but a full-text index is essentially an advanced text only index which uses word stemming to make ...Answered | 3 Replies | 3583 Views | Created by David92595 - Wednesday, May 9, 2012 12:03 AM | Last reply by Ajith Krishnan - Thursday, May 10, 2012 4:58 AM -
0 Votes
Maintaining a Full Text index
Hello All, I am working on Full Text indexes maintenance.Answered | 3 Replies | 1473 Views | Created by krishh.kk - Wednesday, July 6, 2016 4:00 PM | Last reply by Olaf Helper - Wednesday, July 6, 2016 5: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 | 10324 Views | Created by wakthar - Thursday, January 22, 2009 9:28 PM | Last reply by wakthar - Tuesday, January 27, 2009 4:04 PM -
1 Votes
full text index
Would you please check-out What Can I Do with Full-Text Search?Answered | 1 Replies | 2352 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
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 | 2444 Views | Created by Butmah - Tuesday, March 18, 2014 7:32 AM | Last reply by SQLWork - Friday, March 21, 2014 3:51 PM -
0 Votes
Full Text indexing returning Error '0x80fc7586'
The error code is pasted right from the SQL Full Text log.Answered | 10 Replies | 2226 Views | Created by LeeBear35 - Wednesday, October 28, 2015 7:01 PM | Last reply by LeeBear35 - Monday, November 2, 2015 2:20 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 | 1680 Views | Created by anaylor01 - Sunday, August 28, 2016 10:19 PM | Last reply by S_NO - Monday, August 29, 2016 1:14 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 | 3356 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
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 | 3560 Views | Created by John _ PL - Friday, May 14, 2010 5:15 PM | Last reply by John _ PL - Friday, May 14, 2010 6:43 PM -
0 Votes
Tracking Disk Space with Full Text Index
Only when you choose to update the full-text index (ALTER FULLTEXT INDEX...START UPDATE POPULATION) is the base table’s data read and parsed into the ...Answered | 3 Replies | 7999 Views | Created by Sambasiva Reddy - Monday, April 2, 2012 10:14 AM | Last reply by Bob Beauchemin - Friday, April 6, 2012 1:56 AM -
1 Votes
Verify if full text index is indeed successful on a table
In our application we create a table and full text index on that table at run time and insert data into it.Answered | 3 Replies | 6417 Views | Created by TanuShri - Thursday, April 12, 2012 6:51 AM | Last reply by TanuShri - Friday, April 13, 2012 4:41 AM -
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 | 8155 Views | Created by dvdavid2001 - Wednesday, June 29, 2011 7:26 AM | Last reply by dvdavid2001 - Sunday, July 10, 2011 10:52 AM -
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 | 1369 Views | Created by NewBeeMS - Thursday, June 4, 2015 3:59 PM | Last reply by NewBeeMS - Friday, June 5, 2015 1:20 PM -
0 Votes
From GRID to Full TEXT
Give name for your full text catalog, assign a owner , define its living area on the disk subsystem.Answered | 6 Replies | 6981 Views | Created by John_Bristol - Tuesday, October 27, 2009 6:37 PM | Last reply by Lekss - Thursday, October 29, 2009 1:01 AM -
0 Votes
How does full text index search works?
You are taking about full text index in SQL server.Answered | 1 Replies | 1326 Views | Created by Jassik112 - Wednesday, June 24, 2015 1:36 PM | Last reply by Inderjeet Singh Jaggi - Wednesday, June 24, 2015 2:09 PM - Items 1 to 20 of 889352 Next ›
No announcements
