Results 1 to 2 of 2

Thread: largest tables

  1. #1
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110

    Unanswered: largest tables

    Hi,

    Is there an easier way to determine which tables in a db are the largest other than running sp_spaceused for each table? Interested mainly in physical size.

    Thanks

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208

    Re: largest tables

    Originally posted by bmalar
    Hi,

    Is there an easier way to determine which tables in a db are the largest other than running sp_spaceused for each table? Interested mainly in physical size.

    Thanks
    Go to Ed Barlow's homepage http://www.edbarlow.com/ and download the Extended Stored Proc package.

    1> exec sp__helptable

    Table Name Rows Res KB Usd KB Rows/KB Segment Cr Date
    ------------------ ------ ------ ------ ------- ---------- -------
    alerts 420 176 146 2.87 default 24Jan96
    audit_trail 4 62 6 0.66 default 24Jan96
    comn_database 4 32 6 0.66 default 24Jan96
    comn_dumpdevices 3 32 6 0.50 default 24Jan96
    comn_syscolumns 593 160 138 4.29 default 24Jan96
    comn_sysdevices 2 32 6 0.33 default 24Jan96
    comn_sysindexes 70 32 16 4.37 default 24Jan96
    comn_syslocks 0 16 2 0.00 default 24Jan96

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •