klaushaidinger.com

Icon

Finding the biggest tables in a database

One nice feature about SQL Server is the source code for system stored procedures, is readily available. sp_spaceused, which is a nifty little (master) sp that will tell you how big your datbase is, can be opened and viewed just like any other sp. I did some changes and voilá: run this small script to find out the biggest tables in your database.

Download Script: bigtables

Category: Microsoft Sql Server

Tagged:

Comments are closed.