This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
For some reason, FULL TEXT search on my database takes too long to complete the first time. I mean the first time I perform it, it takes about 30 seconds to search the table (which is really small - only some 13 records). However, it then works fine for some time...
I tried using Management Studio, and get same performance issues.
Here is the sql statement I use:
SELECT * FROM Report WHERE FREETEXT([description], 'report')
Presumably its indexing the table on demand rather than upfront. On a full SQL Server install there is a free text search service that does this in the background, but since Express is not intended as a production database I would guess it doesn't do this. Not sure if this is correct, but you can check if there is a free text service running and if there isn't this may be how it is behaving.