Display Rows/Space Used by all user tables

This procedure will display the rows, reserved, data, index and unused space used in KB for all user tables in the database.  The idea is to call sp_spaceused repeatedly.  Limitation: certain versions of sp_spaceused will truncate the table name to 20 characters.Speed will depend on current activity level and locking in the database.  It will […]

2002-03-14

387 reads

Blogs

Heading Font Weights and List View Toggles Arrive in Block Editor and WordPress 5.8

By

With the WordPress 5.8 release, we're starting to introduce features that overall improve your...

My Application is Getting SQL Timeout Errors, But What Query is the Problem?

By

This is something that comes up time and time again. A developer or member...

Daily Coping 27 Jul 2021

By

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

Read the latest Blogs

Forums

How to find islands and get max and min range values

By itlk

I am trying to create groups for each Name and save the max and...

FISCAL_WEEK from 1 Jan till First Friday

By birajdarmm@gmail.com

Hi, We have one requirement. Wee need to create a fiscal_week column in SQL_server...

FISCAL_WEEK from 1 Jan till First Friday

By birajdarmm@gmail.com

Hi, We have one requirement. Wee need to create a fiscal_week column in SQL_server...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers