Get all user def table info with rowcount and size

• Mohit Nayyar

  Ten Centuries

  Points: 1008

  More actions

  September 26, 2007 at 5:36 pm

  #181217

  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

  More actions

  November 19, 2007 at 8:00 am

  #752295

  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

  More actions

  January 23, 2008 at 2:25 pm

  #771058

  hi,

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

  thx

  sreejith

  MCAD

• Slick84

  SSCertifiable

  Points: 5602

  More actions

  June 6, 2011 at 7:55 am

  #1334397

  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

  More actions

  May 12, 2016 at 7:35 am

  #1878627

  Thanks for the script.