Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server 2005 vs SQL Server 2008
Message
 
 
To
30/03/2011 14:24:07
General information
Forum:
Microsoft SQL Server
Category:
Full text indexing
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01505558
Message ID:
01505567
Views:
49
This message has been marked as a message which has helped to the initial question of the thread.
>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 2008
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform