Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting row count as part of DB design info
Message
De
04/02/2008 13:12:31
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01289085
Message ID:
01289160
Vues:
22
>>>>Of course, even if MS did remove them, they are easily access in the Master DB, and could be copied to the new version (assuming no underlying functionality was lost). I am going through them and trying to understand how they work.
>>>
>>>You may want to write several versions of this SP based on various techniques (sysindexes - may be not 100% accurate), sp_MS_ForEachTable, your original cursor approach, Borislav's version and then compare speed for each one of them.
>>
>>Not a bad idea, though the results will be close. We are not iterating through a long list, there are only about 150 tables in this database. Actually that may be not a small number of tables for a database, but not a large number for a query. :)
>
>I think it's a big number and the difference will be shown. But I don't know for sure.

I will give it a try. I think it is a good idea for several reasons. Thanks again.
Thank You

Rollin Burr

Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform