Post reply

Total Database Information At Your Fingertips Part - II

  • November 23, 2011 at 9:57 pm

    #252539

    Comments posted to this topic are about the item Total Database Information At Your Fingertips Part - II

    [font="Comic Sans MS"]Rahul:-P[/font]

  • November 23, 2011 at 9:57 pm

    #1412543

    Thanks for sharing.

    Thanks

  • November 24, 2011 at 2:17 am

    #1412588

    There is faster way how to determine total number of rows in table, then in all tables as well. If you have primary key on your table (so it doesn't works that simply for heap tables) you can just simply select rowcnt column on sysindexes where id = objectid('yourtable') and indid = 1.

    This gives you number of rows in your primary key, which is the number of rows in your table. Subsequently if all tables in your database has a PK, just simply sum all rowcnt columns in sysindexes table.

    Jan

  • November 25, 2011 at 6:49 am

    #1412981

    Hi,

    See if this is something along your lines of DBA information/metadata also.

    You may be able to use/share the code.

    Oliver

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply