You are currently browsing the monthly archive for September 2008.
For those into these kind of things, the excellent Kryoton Suite has reached the grand old age of 3 – its a superb control suite for use in Windows Applications and allows you to create the most eye catching software. It is also very reasonable for us developers on a budget 
.
I found this superb guide to google chrome, loads of shortcuts and hidden gems to play around with.
http://lifehacker.com/5045904/the-power-users-guide-to-google-chrome
Anyone else find expressions in SSIS really not that easy to find information on? well, MSDN for a change comes to the rescue…
I was lucky enough to visit Microsoft during the CTP period and was testing out integrated full text search in 2008. An issue we experienced was that full text can be slow when there is a high number of updates to the index and is caused by blocking on the docidfilter internal table.
It appears to happen if:
- You have AUTO tracking on your full text indexes; although we changed it to manual and still had this issue.
- You experience Full-text queries taking a long time to execute; normally when updates are happening at the same time so you might only see this in production.
- One or more of your queries are complicated or take some time to complete.
You can check to see if your system is slow due to this by:
- SELECT * FROM sys.dm_os_wait_stats statement , it shows very high wait times some of the locks.
- Running Sp_who2; it should consistently show that the full-text gather is blocking full-text queries and, in turn, is being blocked by the queries.
The current work around for this issue is to use a global trace flag microsoft kindly enabled on the RTM build. To use this, type the following Transact-SQL statement:
DBCC TRACEON (7646, -1)
This has a minor side-effect.. which may or may not be important in your organisation. Certainly in ours, it is not. Your full text result may be ever so slightly out of date – e.g. you might return or not return a particular document from the index. However, this issue relates to the dirtyness of an index in terms of 10’s of milliseconds. Important? Unlikely….
I believe there is a knowledge base article on this.
Some great 2008 material here:
http://sqlserver2008jumpstart.microsofttraining.com/content/info.asp?CcpSubsiteID=69&infoid=27
If you are using Visual Studio Team System you get Microsoft’s Test built in and you are able to easily using unit testing against MVC. However, if you want to use NUnit or another testing framework you need to carry out a few steps at the moment.
Follow this really easy tutorial for getting it work.
http://quickstarts.asp.net/3-5-extensions/mvc/MVCCustomTestFramework.aspx
A template will be available soon from NUnit I believe but as at the time of this article it is not ready to download.
Are you having issues installing Google Chrome? Cant get the install because of it being blocked? Well , here is is the link to full install if you need it.
http://cache.pack.google.com/chrome/install/149.30/chrome_installer.exe
If the above link no longer works, it because there is a newer version available. Simply check what the latest version is and replace 149.30 in the link with whatever the version is.
We have an issue currently with the Word Breaker in Full Text Search. Using SQL 2008 , we were able to identify what was actually being parsed using the new sys.dm_fts_parser function.
In German they have compound words. Using the German Word Breaker it should split these compound words out. If you use the following query in SQL 2008 you will see this works for the word used in the example:
SELECT * FROM sys.dm_fts_parser
(‘wirtschaftsprüfung’, 1031,0,0)
However, not all german compound words are split. If you use the same function with ‘Installationsingeneur’ :
SELECT * FROM sys.dm_fts_parser
(‘Installationsingeneur’, 1031,0,0)
It does not split the word at all.
I want to ask anyone out there if there is an answer to this.
