Contents tagged with Sql Server Full-Text Search
-
Back to playing with my Web Search Spider
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 have it running on my 32 bit laptop right now. I am going to get it going in Win64 for x64. Things to do:
-
Our ADO.NET Version 2 Book Cover
-
I am the Database Geek of the Week
http://www.simple-talk.com/2005/05/19/database-geek-of-the-week-wally-mcclure/
-
Full-Text Search Chapter
I have just emailed my full-text search chapter to my publisher. If you are reading this, I was successful and my laptop was not stolen before I sent it off. Yippeee..............
-
Want to see what Full-Text Search Filters are currently running on Sql Server 2005?
Call the sproc sp_help_fulltext_extensions. You will get a list of the file types and the location of the filter along with some additional information.
-
Full-Text Indexing a PDF file with Sql Server 2005 December CTP (aka Yukon)
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).
-
Using a prefix with Full Text Search in Microsoft Sql Server 2005
I remember a long time ago having problems with trying to run a query in Sql Server 2k FTS where I had something like:
-
Full-Text Catalogs in the master, model, or tempdb databases
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 always thought it a good idea not to go changing things in them.
-
Thanks to John Kane
Just wanted to thank John Kane for his suggestions regarding Full-Text Searching. John has a very informative blog on Full-Text Searching.
-
Full-Text Search Chapter Outline is now completed
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 now.