Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Number of records
Message
De
03/05/2011 09:55:25
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Scripting
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01509194
Message ID:
01509204
Vues:
29
>Check my blog post
>http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/how-to-get-information-about-all-databas
>
>I believe I do have this script there (may be even a few).

I executed the one "Record Count in every table in a database". It is very slow. I am better off just to scan all my tables one by one and execute the other script which provides instant result. Is that the script you were referring to?

However, when I executed "Sizes of All Tables in a Database", that one gives an instant result and provides all the fields as the script I initially provided. That one seems to be the good one to use.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform