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

    Thanks
    Mohit Nayyar
    http://mohitnayyar.blogspot.com/
    "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

    SSCommitted

    Points: 1813

    hi,

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

    thx

    sreejith

    MCAD

  • Slick84

    SSCertifiable

    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.

    --
    :hehe:

  • 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