Analyze Space Used for each Table

The following batchfile demonstrates how to use Windows command extension to extract the values of sp_spaceused for each table in the database. The output of sp_spaceused itself contains strings that do not get easily analyzed. The batch file extracts the numbers and outputs the sizes for each table in the database.Copy the batchfile to a […]

2002-02-18

2,255 reads

Blogs

Cloud Computing: Myths, Mysteries, Vampires & Vultures - a free seminar to help you learn more about "the cloud".

By

To be honest you probably think that migrating to the cloud sounds great, and...

DBCC CHECKDB – Msg 7928, Level 16, State 1, Line 3 The database snapshot for online checks could not be created.

By

Do you execute DBCC CHECKDB on your Azure SQL Database? From past experience I...

Introducing Data Céilí Dublin 2020 – Ireland’s newest Data Platform event

By

Today we have launched Data Céilí Dublin 2020, Ireland’s free, community led, Microsoft Data...

Read the latest Blogs

Forums

Index Usage

By juniorDBA13

Hi, I have some indexes on a table that have high user seeks and...

Problem with decimal seperation in Dimension

By ktflash

Ahoi, i want to add an Number value into a Dimension because situationally needed...

deadlock issue

By vsamantha35

Hi Experts, We are seeing repeated deadlocks on one of our prod servers. Can...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers