Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Simplest way to add one table from VFP to SQL Server
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00767389
Message ID:
00767687
Vues:
11
>>Michel, why are you concerned about losing the indexes? Why don't you just let the SQL Server Index
>>Tuning Wizard handle it for you?
>
>Is the SQL Server Index Tuning Wizard able to recognize all existing indexes and apply them? When
>I imported, I lost all indexes I had. How show I proceed to make sure when I import that they are
>being imported as well?

You might not actually want the existing indexes on the back end. The indexes that support Rushmore might be different than the indexes that support your SQL Server optimization. Run some real-world type queries against your data, let SQL Server build the statistics for a bit, and then see what it wants you to have for indexes.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform