Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Check Used Table Space for User Defined Tables

By Tiger,

Often SQL Server Database Administrators struggle with hard disk space and constantly strive to clean up ‘Tables’, writing many queries to find which Table uses the most hard disk space.

This article illustrates how to query the System Tables to find the space usage, which helps Database Administrators identify the Tables that are using the most space in order to archive the old data and purge un-necessary data.

1. Logon to the SQL Server Instance [SQL Server 2005 or SQL Server 2008].

2. Navigate to the database that you want to get the space information on.

3. Copy and Paste the code to your Query Window and Execute it.

4. Check the Results and view the Used Table Space within the selected Database.

Total article views: 1198 | Views in the last 30 days: 4
 
Related Articles
FORUM

QUERY: GET SPACE USED/FREE in All Databases

QUERY: GET SPACE USED/FREE in All Databases

ARTICLE

Monitoring Drive and Database Free Space

SQL Server will autogrow your databases as they run out of space. But the process doesn't manage spa...

FORUM

Sql 2000, Database don't have available space

Sql 2000, Database don't have avialable space

BLOG

Drive Space

I found a cool series of scripts from Jeremiah Peschka on getting disk space from SQL Server. They’r...

ARTICLE

Managing Disk Space

How often do you worry about your database size and free space? Steve Jones asks how you administer ...

Tags
storage management    
t-sql    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones