SQLServerCentral / Article Discussions / Discuss content posted by Mohit Nayyar / Article Discussions by Author / Get all user def table info with rowcount and size / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 23:39:58 GMT20RE: Get all user def table info with rowcount and sizehttp://www.sqlservercentral.com/Forums/Topic403270-613-1.aspxIt 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.Mon, 06 Jun 2011 07:55:40 GMTSlick84RE: Get all user def table info with rowcount and sizehttp://www.sqlservercentral.com/Forums/Topic403270-613-1.aspxhi,its soo helpful script for me. so simple to run. really appreaciatable.thxsreejithMCADWed, 23 Jan 2008 14:25:23 GMTSreejithsqlRE: Get all user def table info with rowcount and sizehttp://www.sqlservercentral.com/Forums/Topic403270-613-1.aspxIf 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;Mon, 19 Nov 2007 08:00:16 GMTMark Ellis-431978Get all user def table info with rowcount and sizehttp://www.sqlservercentral.com/Forums/Topic403270-613-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Miscellaneous/31992/">Get all user def table info with rowcount and size</A>[/B]Wed, 26 Sep 2007 17:36:42 GMTMohit Nayyar