September 26, 2007 at 5:36 pm
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"
November 19, 2007 at 8:00 am
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;
January 23, 2008 at 2:25 pm
hi,
its soo helpful script for me. so simple to run. really appreaciatable.
thx
sreejith
MCAD
June 6, 2011 at 7:55 am
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:
May 12, 2016 at 7:35 am
Thanks for the script.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy