Appropiate that this is my first post in 2006. I spent several hours this evening working getting my web search spider back up and going. I have it running on .NET 2.0 with Sql Server 2005. I need to go back and make a stored procedure change or two and it will be ready for me to scale it back up. I...

I just got finished installing and setting up the full-text indexing of a pdf file for Sql Server 2005 December CTP Build. Here are the steps to getting it working (assuming you have a functioning table to store BLOB data). Remember that your table must have a BLOB field, such as a varbinary(max), and...

I remember a long time ago having problems with trying to run a query in Sql Server 2k FTS where I had something like: SELECT COL1, COL2, COL3 FROM TABLE WHERE CONTAINS(COL1, 'TERM*') I wanted the rows where a word came back that started with TERM. I never ever could get back what I wanted. In reading...

In reading through the documentation on Sql Server 2005, it states that a full-text catalog can not be created in the master, model, or tempdb databases. The more interesting question to me is "Why would I want to do create a catalog in those databases?" I've always stayed out of those databases and...

I think I have just about completed my outline for the Full-Text Search Chapter Outline is just about completed and I have written some content. I'll probably have a few changes to the outline, but I like where I am at now. I'm really excited about this. I can honestly see the finish line of this book...

Hmmm, nice. With Sql Server 2005, Microsoft will introduce DDL statements to managed full-text indexes and catalogs. CREATE FULLTEXT CATALOG........... CREATE FULLTEXT INDEX............. ALTER FULLTEXT INDEX............... It looks like the system stored procedures are still there, but that it is being...

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...

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...

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. Wally

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...