HowTo - Check the sizes of individual tables in SQL

Expand / Collapse
 

HowTo - Check the sizes of individual tables in SQL


Article ID: 52426 - Last Review: March 9, 2016

PROBLEM

Your CCMData SQL database is growing, and you want to identify which table or tables are accounting for the size


RESOLUTION

1. Download the attached TableSizes.ZIP to the SQL server (or any server with SQL Management Studio able to connect to your SQL server)
2. Unzip the file and run the TableSizes.SQL file 



APPLIES TO

MiCC all versions 

Keywords: SQL database table size sizes growing



Rate this Article:
     
Tags:

Attachments


TableSizes.zip TableSizes.zip (798 GB, 699 views)

Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:Wednesday, March 09, 2016
Last Modified By: AndrewMontpetit
Type: HOWTO
Article not rated yet.
Article has been viewed 4,332 times.
Options