February 28, 2008 at 12:40 pm
how guys, is there a way to display the sizes of all the tables and number of rows in a database without having to create a sp?
February 28, 2008 at 12:45 pm
For some reason I've seen this disabled on occasion, but assuming your install is "fully functional": right-click on the database name, pick "reports", "standard reports", "disk usage by table".
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
February 28, 2008 at 12:59 pm
You can try this script and change the order by if needed
select convert(varchar(30),
object_name(id)) [Table Name],
rows
from sysindexes
where object_name(id) not like 'sys%' and indid = 1
order by object_name(id)
¤ §unshine ¤
February 28, 2008 at 1:03 pm
Script to analyze table space usage
February 28, 2008 at 1:08 pm
thank you!!! it worked, i ran the script in the forum. 🙂
February 28, 2008 at 1:10 pm
DBA (2/28/2008)
in management studio? i don't get anything when i righclick that says reports
You probably don't have SP2 installed 😉
* Noel
February 28, 2008 at 1:14 pm
After installing SP2 take a look at http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en
These Performance reports are very nice
Francis
February 28, 2008 at 1:22 pm
Also - do the management reports work in Express? do they work in every version? (with SP2 on)
I could swear I had an SP2 install, and nothing under right-click. I ended up reinstalling with Dev edition, and boom - reports on the right-click.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
February 28, 2008 at 1:33 pm
wow thank you!
February 28, 2008 at 4:45 pm
You can use this query thats given below too.
http://www.sql-articles.com/index.php?page=Scripts/sp_details_tbl.php
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply