No announcements
Found 2478592 threads
-
0 VotesFull Text Index Query - SQL Server 2005
I believe you need to update your noise word list in your SQL server instance.Answered | 6 Replies | 6296 Views | Created by NandipMakwana - Tuesday, March 22, 2011 1:10 PM | Last reply by Steven Wang - Shangzhou - Wednesday, March 23, 2011 6:05 AM
-
0 Votes
MS SQL Server 2005 and Full Text Indexing
However why dont you see " Replicating Full-Text Indexes in SQL Server 2005" See below link.Answered | 1 Replies | 6470 Views | Created by SASFSU - Wednesday, October 21, 2009 2:02 AM | Last reply by Bikash Dash - Wednesday, October 21, 2009 4:48 AM -
0 Votes
full text search in sql server 2005
Download the SQL Server 2005 Express Edition with Advanced Services from this link -Answered | 3 Replies | 5738 Views | Created by skej - Thursday, November 12, 2009 6:59 AM | Last reply by Lekss - Thursday, November 12, 2009 7:55 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 | 6315 Views | Created by dvdavid2001 - Saturday, November 28, 2009 6:47 AM | Last reply by dvdavid2001 - Sunday, November 29, 2009 2:30 PM -
0 Votes
Tempdb Use full text indexing
Note, however, that during upgrade of a SQL Server 2005 database, any full-text catalog that contains data files, a new filegroup is created; for ...Answered | 2 Replies | 1667 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
Replicating Full Text Index (Publisher: SQL Server 2008R2 Standard)
Hi Targray, Firstly, SQL Server 2008 R2 supports full text Index replication to SQL Server ...Answered | 3 Replies | 1234 Views | Created by Targray - Thursday, August 6, 2015 2:21 PM | Last reply by Lydia Zhang - Friday, August 7, 2015 6:39 AM -
0 Votes
Checking ampersand in full-text index
Do you have any idea for this thing in SQL Server 2005?Answered | 6 Replies | 8140 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
Would you please check-out What Can I Do with Full-Text Search?Answered | 1 Replies | 2339 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
Hi Vinod, As described in this blog, index fragmentation could be caused by various causes.Answered | 5 Replies | 1642 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 | 5547 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
SQL Server Full Text Index with Joins
I am sure Full Text Index shall be faster as compared to above operators.Answered | 4 Replies | 1751 Views | Created by contacthirenparikh - Tuesday, March 13, 2018 2:10 PM | Last reply by contacthirenparikh - Wednesday, March 21, 2018 7:40 AM -
0 Votes
SQL Server 2008 R2 Express Edition and Full Text Indexing
I am at present re-testing replication of the full text catalog from our production SQL Server to the web facing server.Answered | 4 Replies | 7565 Views | Created by miner49er - Wednesday, December 7, 2011 6:56 PM | Last reply by miner49er - Friday, December 9, 2011 6:19 PM -
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 | 3565 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
Is the SQL Server "Full-text indexing" feature needed for SharePoint 2010
Would there be any re-percussions to enabling full text indexing on the SQL Box?Answered | 12 Replies | 9231 Views | Created by Carlo.G - Wednesday, May 30, 2012 5:00 AM | Last reply by AdamDoubleYou - Wednesday, December 13, 2017 7:38 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 you can ...Answered | 2 Replies | 2253 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
Full-Text Indexing Windows Azure Sql Server 2008 R2
The following thread is on the topic of SQL Azure full text indexing not being available:Answered | 1 Replies | 1752 Views | Created by Robert E. Burton - Sunday, April 6, 2014 10:23 PM | Last reply by Kalman Toth - Monday, April 7, 2014 12:40 AM -
0 Votes
Full Text indexing search issue
Article: Creating and Customizing Noise Words in SQL Server 2005 Full Text ...Answered | 1 Replies | 3344 Views | Created by Johnson Samuel - Friday, October 7, 2011 5:23 AM | Last reply by Kalman Toth - Friday, October 7, 2011 11:01 AM -
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 | 10310 Views | Created by wakthar - Thursday, January 22, 2009 9:28 PM | Last reply by wakthar - Tuesday, January 27, 2009 4:04 PM -
1 Votes
Indexes on Varchar field SQL Server 2005
Consider full-text index for wide text columns.Answered | 9 Replies | 4149 Views | Created by Shweta M - Friday, March 1, 2013 8:24 AM | Last reply by Gert-Jan Strik - Saturday, March 2, 2013 5:13 PM -
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 ...Answered | 5 Replies | 2427 Views | Created by Butmah - Tuesday, March 18, 2014 7:32 AM | Last reply by SQLWork - Friday, March 21, 2014 3:51 PM - Items 1 to 20 of 2478592 Next ›
No announcements
