Please start any new threads on our new site at https://forums.sqlteam.com. 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 

AskSQLTeam
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.

karl@karlp.com
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.

Thanks

Karl
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

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

[url]http://vyaskn.tripod.com/sp_show_biggest_tables.htm[/url]

Harsh Athalye
India.
"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
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

CODO ERGO SUM
Go to Top of Page

robvolk
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:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53843
Go to Top of Page
   

- Advertisement -