Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reindex all tables routine
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01513352
Message ID:
01513360
Vues:
46
>In my VFP application that works with VFP database I have an item on the main menu to reindex all tables (using SDT). Now as I am moving to SQL Server I am wondering, is it a common practice to have the same item in the VFP application menu? That is, to have the application to reindex SQL Server tables? Or this is more commonly done by a DBA?
>
>TIA.


This is done by Maintenance plans defied by you or DBAs.
If you (DBA) can't define such plan (because of Express editions of SQL Server) you could use DBCC commands.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform