A possible fix to slow performance in SQL 2008 integrated full text search.
September 4, 2008
Question on Full Text Search Word Breaker for Gemany
August 27, 2008
Advanced services and tools now available for SQL Server 2008
June 26, 2008
A nice and easy one but worth sharing. We had an issue on our dev environment where the stored procedure managed to get a really yucky query plan, to resolve this you can DROP and CREATE the procedure or you can use sp_recompile. To use , you call sp_recompile with the object name you want […]
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 […]
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 […]
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 […]
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 […]
April 15, 2008
This article shows a practical use for dynamic SQL and FOR XML.
February 24, 2008
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) […]
September 16, 2008
2