Here is query you can find out biggest table in the system. top clause can be modified to display top 10,100 biggest tables in the system.
select top 1 databasename, tablename ,sum(currentperm) from dbc.tablesize group by 1,2 order by 3 desc;
select top 1 databasename, tablename ,sum(currentperm) from dbc.tablesize group by 1,2 order by 3 desc;
No comments:
Post a Comment