A possible fix to slow performance in SQL 2008 integrated full text search.
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, […]
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 […]
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 […]
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 […]
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 […]
Bug found in CTP6 related to the new Integrated Fulltext Search, if you are experiencing issues you should read this post.
All being well I should be flying off to the States within the next couple of weeks to spend some time with Microsoft and specifically iFTS. If anyone has any burning issues or questions they would like to raise, please respond to this blog. My time is pretty much focused on our company’s application and […]
One neat feature of SQL Server 2008 is the ability to see how fragmented your fulltext indexes are. By running the following you can see how many fragments you have. SELECT * FROM sys.fulltext_index_fragments The rule of thumb is that if you have between 30-50 fragments per table you should be thinking of reorganizing (REORGANIZE) […]
As SQL Server 2008 CTP6 is now with us I will be doing a post on the new integrated full text search (iFTS) shortly. iFTS includes a number of key changes including support for STOPLIST, mixed query performance, thesaurus improvements and of course full text indexes are stored and maintained inside SQL Server now. There […]