• I hope sql2008 iFTS has some good features too.

    When using Turbo it can return total number of matches found extremely quickly even searching millions of rows. I struggle to see how SQL using fts will be able to do this without having to return back all the rows in the query and then counting them etc. I hope Microsoft will prove me wrong but i'm not holding up much hope.

    I did find on the web that Microsoft have purchased a Scandinavian Enterprise class search tool so may be they will bring this in line in a few years.