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
ThanksMohit Nayyarhttp://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
its soo helpful script for me. so simple to run. really appreaciatable.
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.
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