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,257 reads

Blogs

What Agent Jobs are Running??

By

Do you run SQL Agent Jobs in your environment?  Do you know what is...

Unboxing SQL Clone 2020 for a PoC

By

When I got a new machine, I had SQL Clone on my old machine,...

Daily Coping 4 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Secondary replica is down at moment

By vivekinmadar

Hi Team , We have three node cluster setup where the one primary server...

SQL 2016 vs SQL 2008R2 float to numeric Difference:

By inayatkhan

Hi, we are upgrading from SQL server 2008 R2 to SQL server 2016 between...

Extended Events

By Michael L John

I have set up an extended event to capture the queries users may be...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers