SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Finding the biggest tables in a database		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts
Posted - 08/04/2000 :  11:27:37  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
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 Posts
Posted - 09/13/2006 :  02:30:02  Show Profile  Visit karl@karlp.com's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

India
5509 Posts
Posted - 09/13/2006 :  03:01:24  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
Also check this link:

http://vyaskn.tripod.com/sp_show_biggest_tables.htm

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

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
6997 Posts
Posted - 09/13/2006 :  10:03:03  Show Profile  Reply with Quote
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

USA
15559 Posts
Posted - 09/13/2006 :  14:44:08  Show Profile  Visit robvolk's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000