Tagged Questions
3
votes
0answers
20 views
custom population of full text index
Is there any way to populate a full text search index without storing the backing information in the database?
I don't mean using remote-blob-storage or FILESTREAM types. The backing information is a ...
2
votes
1answer
30 views
Audit full text activity
I need to find when and which user created full text catalog, and who added/modified/deleted the columns (that were full text indexed) in that full text catalog.
0
votes
1answer
49 views
Can I use the database and query it while full-text indexing?
I need to index my database, but I need to query it while it is indexing, it may take a long time, can I do that?
2
votes
1answer
63 views
Reorganize full text catalog is offline or online?
I need to schedule a Full Text Search Maintenance and I was reading this link: http://msdn.microsoft.com/en-us/library/ms176095.aspx. Reading this documentation I am supposing that I need to ...
5
votes
1answer
67 views
BM25 (full-text search) implementation in SQL Server
I've hit a stump, while trying to implement the BM25 algorithm in SQL Server 2008 R2. I know that SQL Server includes the Full-Text Search option, which already implements a variant of BM25, but I ...
1
vote
1answer
28 views
Full-text search migration 2005 -> 2012 (.ndf file?)
So I'm trying to figure out the details for migrating from SQL Server 2005 to SQL Server 2012.
I tried to do restore and backup of a DB from 2005 to 2012. This worked well and for the text search ...
2
votes
0answers
23 views
Combining full-text-search queries
I have two tables in a SQL Server database with basic fulltext indexes:
CREATE FULLTEXT CATALOG table1_catalog;
CREATE FULLTEXT INDEX ON table1
(
name1
)
KEY INDEX pk_table1
ON ...
3
votes
1answer
26 views
Fulltext stoplist replication
In MS SQL Server 2008 R2 there is replication of table with fulltext index on it.
But stoplist that is associated with replicated fulltext index doesn't replicate.
Is there any possibility to ...
1
vote
0answers
117 views
sql server full text search - fuzzy searching?
Is there a way to configure fuzzy searches in sql server full text search. Meaning if I search for a term called POWDER, I must get matches (i.e. strings) which contain any variations of it within an ...
0
votes
0answers
31 views
Full-text search index size
Is there any analysis about this topic? For example what is the estimated index file size of 1 GB .txt files?
2
votes
0answers
56 views
How do I get more details on a full text catalog error?
I have an error that is repeatedly generated on a SQL Server 2005 instance running the databases for MS Team Foundation Server.
'Severity 16' occurred on INSTANCENAME
Looking in the SQL Server ...
2
votes
1answer
55 views
Are there differences in performance of getting data between FullText Search and indexed columns
In SQL Server 2008 R2 I have a query which looks like
create stored procedure give_me_art @filter varchar(15),@skl_id int
begin
select
id,naziv,sifra,isnull(lager.kolicina,0) as lager
from art
...
1
vote
1answer
103 views
Installing Full Text Search on SQL Server 2008 R2 Express
I can't for the life of me install full text search on my SQL Server 2008 R2 instance.
Every installer I have tried shows me this:
I've tried:
SQLEXPRADV_x64_ENU.exe
SQLEXPRWT_x64_ENU.exe
...
2
votes
0answers
39 views
improving this goal query
Goal
joining the two tables: tbl_quickSearchParam (fulltext search results) against tbl_product ( active products : prod_status = 1, group by prod_image_name)
create table tbl_product (
...
0
votes
1answer
139 views
Find fulltext indexes in SQL Server 2008
How do I find a list of tables that have a FULLTEXT INDEX applied to them on a given database?
For example, you can enable and disable a FULLTEXT INDEX like this:
ALTER FULLTEXT INDEX ON ...
1
vote
1answer
313 views
SQL Server Full-Text Indexer with stoplists/stopwords
As I'm working on a graduate project (Textmining with SQL Server 2012 Semantic Search) I run into a situation where I need to post a question on this website, hoping someone can help me.
This ...
9
votes
2answers
358 views
SQL Server Filetable document properties
I'm using SQL Server 2012's Filetable to store documents and search them with Semantic Search.
I was wondering if there is a way to list all the document properties (meta data). There is a way to ...
2
votes
0answers
78 views
SQL Server fulltext_semantic_languages
When trying to install a semantic search example, I'm running into a problem.
There are some steps in the example to check if the 'new' Semantic Search and Full Text Search are installed.
...
0
votes
1answer
46 views
SQL Server 2008 Full-Text Search installation
I have full version of SQL Server 2008 R2 on my machine. Only problem is when my computer was created (by the IT Tech's at my work) they did not add the Full-Text Search feature to the installation. I ...
2
votes
0answers
187 views
SQL fulltext accent insensitive
I am using SQL Server fulltext containstable and the column which is indexed has collation Czech_CS_AS, so why when I have word "byt" it returns records with word "být" too. I thought that the ...
0
votes
0answers
256 views
Having trouble creating a unique key for full-text index on an indexed view in SQL Server 2008r2 and I am not sure if the string length is the cause
I am having trouble creating a unique key for a full-text index on an indexed view. My definition is as follows:
CREATE VIEW [dbo].[vw_inventory_metadata] WITH SCHEMABINDING AS
SELECT ...
2
votes
1answer
149 views
SQL Server 2005: Full-text search on a multi-lingual table
I have an articles table as follows.
+-----------+--------------+---------+
| uid | int | PRIMARY |
| articleId | int | UNIQUE |
| lang | varchar(2) | UNIQUE |
| ...
3
votes
2answers
211 views
SQL Server 2005: Full-text search space requirements
Is there a way to calculate the physical drive space required for a full-text search catalog? Space is cheap, but I'd like to know what I'm getting into.
I'm looking at a table of about 200 articles ...
1
vote
1answer
44 views
SQL Server 2005: Full-text search catalog design
I'm new to full-text searches, and am curious about how to properly design the full-text catalogs. I have an "articles" table. I would like to do full-text search on both the "title" and the "body" ...
1
vote
1answer
216 views
SQL Server 2005: Full-text search, order by matches
Is it possible to do a full-text search in SQL Server 2005, ordering on the number of matches?
For example, let's say I have the following products for sale.
Tennis Racquets
Tennis Balls
Footballs
...
0
votes
0answers
328 views
Solr/Luceine vs SQL full text search [closed]
I need a strong argument as to which one is better and why. Can anyone help me out with this research.
1
vote
1answer
58 views
What is the use of creating full text catalog in full text indexing
Just want to know about the processes happening in full text indexing. I know by defining the full text indexing for a table, it will index all the words saved in that table.
But i didn't get the use ...
4
votes
1answer
252 views
Sql Server Full Text Search one table for text values in another table
Is it possible to run a full text search on an FTS-indexed column for all values in another table?
Conceptually it'd look like
select d.* from Docs d, Tags t where CONTAINS(d.fulltext, t.tagvalue)
...
3
votes
1answer
250 views
Full-text index in partitioned table
I have a table with just over a million records with a full-text index.
This table has been split in two in the past, and the data older than a certain date is moved to another table with the exact ...
2
votes
3answers
335 views
Which database is best for deeply embedded database or through C DLL?
I want a deeply embedded database. Deeply embedded means that the server is started by an application and closed by the application with no tcp/ip or 0 port. The main features of consideration are:
...
3
votes
2answers
4k views
Why does simple ALTER TABLE command take so long on table with full-text index?
I have a large (~67 million rows) name-value table that has full-text indexing on the value column (DataValue).
My question is:
If I try to run the following sql command:
ALTER TABLE VisitorData ...
1
vote
1answer
647 views
SQL Server 2008 R2 Most Efficient Full Text Search Field Type
In SQL Server 2008 R2, what is the most efficient column type to store data enabling full text search?
I can currently see two options, nvarchar and varbinary.
Which one performs better and why?
...
4
votes
1answer
630 views
Alternatives to LIKE and FTS for mid name search
I have a question about what are the alternatives for LIKE '%%' and Full-Text Search when it comes to searching organisation names, firstnames, surnames, etc.
The LIKE '%%' causes table scan, however ...
2
votes
1answer
401 views
Can I get similar Full Text Search functionality without using Full-Text Search?
Normally, I wouldn't post this kind of question here, but I can't seem to find anyone who has actually used SQL Server Full Text Search, so I'm posting here.
I'm creating a solution for a client that ...
10
votes
5answers
2k views
SQL Server 2008 Full Text Index Never Seems to Complete
Our website has a SQL Server 2008 R2 Express Edition database with full-text indexing for our website search. Each time a new record is added or updated in one of the indexed tables, the indexing ...
2
votes
1answer
620 views
Are there disadvantages to using Full-Text Search in SQL Server?
Are there disadvantages to using Full-Text Search in SQL Server? Is there much of an increased CPU or memory load on the server?
3
votes
4answers
3k views
Property PopulationStatus is not available for FullTextCatalog… How to fix?
I've created a new catalog (case insensitive, make default catalog), when I try to right click > properties to add tables I get this error:
Property PopulationStatus is not available for ...
