SQL Server Performance Forum – Threads Archive
I need a script to sort all the user tablesFolks, I need a script to sort all user tables based on the row count and storage size? thank you so much, SQL 2K5 EE ——————
Check the following url for script from vyas…it is written for sql 2000 but it should work in 2005 (not tested)… http://vyaskn.tripod.com/code/sp_show_huge_tables.txt
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
See if this is also helpful select object_name(i.id),i.rows from sysindexes i inner join sysobjects o on i.id=o.id
where i.indid<2 and o.xtype=’u’
order by rows
Madhivanan Failing to plan is Planning to fail
You can make use of SP_SPACEUSED onto a temp table and sort it or the above links. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.