ALLINSIGHT

Home of the AlmostImplementedException

How to find large tables in Sql Server

Sometimes it is necessary to find out which tables are consuming the most space in your database. especially when you run your database for a couple of years.
In our case we’ve got an ERP database which holds orders, position, customers, machine controls, print data, … So we need to find table that are predestined for archivating.
With this snippet you are able to find then. Hope that will help you.

Share :

, , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *