Browsing All Posts published on »April, 2008«

FDHost Account Password Expiry Issue In CTP6

April 30, 2008


Simon Sabin posted about this a few weeks back but I hit the issue he described today so I wanted to write about it and what I had to do. The issue I am talking about is related to the account Full Text host uses to perform out of process tasks. This account, in CTP6, […]

Ranking Methods in Full Text Search

April 29, 2008


This is direct from MSDN but I was asked about this specifically so I thought I’d post about it. If anyone has used full text search you will know that the default way it ranks results is pretty good. It uses a known method called Jaccard Coefficient. However, there are times when you might want […]

Personal Firewall

April 28, 2008


I have just finished watching the Gadget show and wanted to blog about a neat personal, usb, linux-based firewall. You basically have to install the drive and plug in.. it works in XP/Vista (32bit I believe). You can check out the details at the Yoggie site , If you are in the UK, […]

Integrated Full Text Search is nearly there

April 28, 2008


Having not long arrived back in the UK and with good intentions to blog like mad during my trip to Seattle, my health whilst out visiting Microsoft unfortunately wasn’t permitting me to do much else after the work I was there to do. I will be posting a more concise post later this week about […]

Fulltext index creation taking a long time?

April 23, 2008


This may be only relevant to 2008 but if you find Fulltext index creation taking a long time to complete you may be affected by a potential bug in CTP6. If you are experiencing this problem you can try running the following statement prior to the creation of the index. This will disable the checking […]

Full Text System Views

April 20, 2008


Here is a summary of the new Full Text System Views in SQL 2008. sys.fulltext_stoplists A list of STOPLISTS in your database. STOPLISTS are database specific. STOPLISTS replace Noise Word Files. sys.fulltext_stopwords This will show you you’re STOPWORDS. You can filter this on the language and or stoplist of your choice. STOPWORDS are individual words […]

Welcome to Seattle

April 20, 2008


Well, this is the first of my blog posts about my trip to Seattle. This is not much more than an introductory hello from me in Seattle. I arrived with a stinker of a cold and due to sinus issues during the descent into Seattle I am currently, largely, deaf. Not a great start to […]