August 3, 2010 at 2:59 pm
Hi friends,
Is there any query or table where we can check size of the tables in a DB. I want to check size of tables & no. of rows in each table. can you please help me.
Thanks in advance.
Mast DBA
August 3, 2010 at 3:06 pm
I have a little series on the topic written at my blog. You can find it here.
http://jasonbrimhall.info/2010/05/05/sql-2005-tablespace/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 3, 2010 at 3:33 pm
This script should give you the information you want.
Script to analyze table space usage within a database
September 1, 2010 at 11:38 am
Thank u so much for ur help.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply