Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting row count as part of DB design info
Message
From
04/02/2008 13:12:31
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01289085
Message ID:
01289160
Views:
21
>>>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform