Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server 2005 vs SQL Server 2008
Message
 
 
À
30/03/2011 14:24:07
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Indexation intégral de texte
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01505558
Message ID:
01505567
Vues:
50
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform