Comments posted to this topic are about the item Get all user def table info with rowcount and size
"If I am destined to fail, then I do have a purpose in my life, To fail my destiny"
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;
its soo helpful script for me. so simple to run. really appreaciatable.
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.
Thanks for the script.
Viewing 5 posts - 1 through 4 (of 4 total)