To know the size of tables in the database:
select object_name(id) [Table Name], [Table Size] = convert (varchar, dpages * 8) + ' KB' from sysindexes where indid in (0,1) order by dpages desc
To Know the size of the databases in the server:
SELECT name, size * (8192/(1024.*1024)) FROM sys.master_files ORDER BY size DESC
No comments:
Post a Comment