>>Thus, if I understand correctly, in 2008 a full text index on SQL Server is among the .mdf file as oppose to have a sub directory under the database for each table that requires it in 2005. When I look at my server, I can see that everything is in the .mdf file. But, in 2005, sub directories apply for each table with a bunch of files under it for the indexing.
>
>Yes
>
>>If it would be just for that point, I assume there could be a gain of performance and that might explain why I cannot simulate the same performance between both servers in two different environments.
>
>I would expect improved performance
>
>>
>>So, basically, once we moved 2008 at the other location, we should benefit from a lot of new performance and interesting possibilities.
>
>You may want to check
Best Practices for Integrated Full Text Search (iFTS) in SQL 2008Thanks