Get all user def table info with rowcount and size

  • Mohit Nayyar

    Ten Centuries

    Points: 1008

    Comments posted to this topic are about the item Get all user def table info with rowcount and size

    Mohit Nayyar
    "If I am destined to fail, then I do have a purpose in my life, To fail my destiny"

  • Mark Ellis-431978

    SSC Journeyman

    Points: 85

    If you'd like to sort by any of the size columns, simply substitute the following ORDER BY clause with the name of the column inserted. As an example I sorted by dataSpace.

    ORDER BY convert(int,reverse(substring(reverse(dataSpace),4,10))) DESC;

  • sreejithsql


    Points: 1813


    its soo helpful script for me. so simple to run. really appreaciatable.




  • Slick84


    Points: 5602

    It would be nice to see performance impact on a production DB while running this during business hours. Though I wouldn't run this during business hours, many unsuspecting people would unless its listed not to do so 🙂

    Thanks for the article and yes this is helpful.


  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

Viewing 5 posts - 1 through 5 (of 5 total)

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