Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: Finding the biggest tables in a database

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2000-08-04 : 11:27:37
This quick article includes a discussion on SQL Server tools to determine the size of tables in a database. It also has a downloadable script I wrote to find the largest tables in a database.

Article Link.
Starting Member

1 Post

Posted - 2006-09-13 : 02:30:02
Good bit of SQL. Just what I needed at 0600 when trying to compare the sizes of tables in a recovered database.


Go to Top of Page

Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-09-13 : 03:01:24
Also check this link:


Harsh Athalye
"Nothing is Impossible"
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-09-13 : 10:03:03
This script does this for all tables in a database, and analyzes the space used per row for data and indexes.

Script to analyze table space usage

Go to Top of Page

Most Valuable Yak

15732 Posts

Posted - 2006-09-13 : 14:44:08
Hmmm, I guess I need to sex this one up a bit, no one seems to notice it:
Go to Top of Page

- Advertisement -