Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Mohit Nayyar » Get all user def table info with rowcount and...
Add to briefcase

Get all user def table info with rowcount and size Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Mohit Nayyar
Posted Wednesday, September 26, 2007 5:36 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 30, 2012 7:36 PM
Points: 148, Visits: 69
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"
Post #403270
Mark Ellis-431978
Posted Monday, November 19, 2007 8:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 17, 2013 9:49 AM
Points: 3, Visits: 111
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;
Post #423617
Sreejithsql
Posted Wednesday, January 23, 2008 2:25 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Saturday, August 25, 2012 9:48 PM
Points: 777, Visits: 134
hi,
its soo helpful script for me. so simple to run. really appreaciatable.

thx
sreejith
MCAD
Post #446643
Slick84
Posted Monday, June 06, 2011 7:55 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, October 31, 2011 1:10 PM
Points: 480, Visits: 1,163
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.

--
Post #1120274
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.