This week's book giveaway is in the OCAJP forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide 1Z0-808 and have Jeanne Boyarsky & Scott Selikoff 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.