Contents tagged with Sql Server Full-Text Search
-
DDL for Full-Text Setup
Hmmm, nice. With Sql Server 2005, Microsoft will introduce DDL statements to managed full-text indexes and catalogs.
-
Detach and Attach Full-Text catalogs in Sql Server 2005 easily
Last year about this time, I was playing around with a web spider that I worked on. Still am, but its on the shelf right now while I work on real things. Anyway, one of my complaints about trying to do full-text search with Sql 2000 was that when I moved the database onto a new drive, I was still seeing utilization on my main drive. One of the cool features of Sql Server 2005 is that the database actually contains the contents of the full-text catalogs. The result is that I can attach and detach databases and catalogs and they move around together because the catalogs are included in the databases. This is sweet. Full-Text Indexing is becoming more and more a full fledged piece of the database.
-
Full-Text Index Incremental Population in Sql Server
If you want to perform an incremental population of a full-text index in Sql Server, you must have a column with the data type of timestamp in each table that you want to index. If you do not have a column of type timestamp, the incremental population will turn into a full population, which is much more resource intensive.
-
Full-Text Search limits
If you want to full-text index a table in a Sql Server 2005 database, there is an internal limit of 2,000,000,000 rows in a full-text catalog. If I remember correctly, this is the same limit in Sql Server 2000, and perhaps Sql Server 7, but I don't have one of those up and running to check.
-
Full-Text Search chapter
I finally set down today and started to outline my full-text search chapter. After I did a basic outline, I started writing. I am happy to say that I have filled up four pages today. I've been working on pulling together background material on how the full-text indexing works in Sql Server and reading through that over the past couple of days. I've used full-text search in Sql Server for several years, but I didn't know before the past couple of days what I know now. Wow, this is really useful and has at least doubled my knowledge of Full-Text indexing.
-
Want to load your own Filter in Sql Server 2005?
Want to load your own filter in Sql Server 2005 to perform Full-Text searching? Unless the filter is signed by a trusted source, you will need to perform:
-
Check the filters installed in your Sql Server 2005 database
Would you like to find out the filters that are installed in your Sql Server 2005 database? Try this: exec sp_help_fulltext_extensions;
-
Full-Text Search in Sql Server 2005 / Yukon Chapter
I am starting to write my Full-Text Search in Yukon chapter. Expect to see some posts coming up on Full-Text Searching.