Subscribe to this blog
Archives: September 2010
Find the largest tables in a database
From time to time, I need to find the largest tables in terms of rows / used space / total space etc. I originally used sp_spaceused, a temp table and a cursor (or sp_MSForEachTable) and put them into a stored procedure to get the information I need.
But now as… Read more
6 comments, 11,226 reads
Posted in DBA Philosophy on 28 September 2010