No announcements
Found 1660694 threads
-
0 VotesSQL 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
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 -
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 | 2249 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 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 -
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 | 10308 Views | Created by wakthar - Thursday, January 22, 2009 9:28 PM | Last reply by wakthar - Tuesday, January 27, 2009 4:04 PM -
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 2005.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
Full Text Index
Hi Vinod, As described in this blog, index fragmentation could be caused by various causes.Answered | 5 Replies | 1640 Views | Created by Vinod Mallolu - Friday, April 24, 2015 10:12 AM | Last reply by Lydia Zhang - Thursday, April 30, 2015 2:24 AM -
2 Votes
Is the SQL Server "Full-text indexing" feature needed for SharePoint 2010
OUr network team wants to deploy a database to our SharePoint SQL box which. requires full text indexingAnswered | 12 Replies | 9230 Views | Created by Carlo.G - Wednesday, May 30, 2012 5:00 AM | Last reply by AdamDoubleYou - Wednesday, December 13, 2017 7:38 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 | 3562 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
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 | 3559 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 | 1355 Views | Created by NewBeeMS - Thursday, June 4, 2015 3:59 PM | Last reply by NewBeeMS - Friday, June 5, 2015 1:20 PM -
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 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 | 1750 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
SQL text of Missing index
In addition, you should not blindly add indexes or missing indexes.Answered | 2 Replies | 1129 Views | Created by arifulhaq - Tuesday, March 21, 2017 11:18 AM | Last reply by Tom Phillips - Tuesday, March 21, 2017 11:56 AM -
0 Votes
How to detect if full text indexing feature is installed in SQL Server 2008
looking for a book on SQL Server replication?Answered | 1 Replies | 9925 Views | Created by Ragesh_Sys_admin - Wednesday, November 18, 2009 11:57 AM | Last reply by Hilary Cotter - Wednesday, November 18, 2009 4:43 PM -
0 Votes
Which Microsoft SQL Server version don't need to create full text catalog and full text index?
Answered | 10 Replies | 1844 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
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 | 5546 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
Tempdb Use full text indexing
Tables->right click->Fulltextindex(greyed out) so- Beginning in SQL Server 2008, the full-text indexes are ...Answered | 2 Replies | 1666 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
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 | 3248 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
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 | 6314 Views | Created by dvdavid2001 - Saturday, November 28, 2009 6:47 AM | Last reply by dvdavid2001 - Sunday, November 29, 2009 2:30 PM - Items 1 to 20 of 1660694 Next ›
No announcements
