Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: 1225 | Views in the last 30 days: 2
 
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...

BLOG

Four Ways to Find Free Space In SQL Server Database

Determine Free Space In SQL Server Database In our previous section we have discussed about Using...

Tags
storage management    
t-sql    
 
Contribute