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

385 reads

Blogs

Viewing the Statistics Objects Used to Create an Execution Plan

By

Use trace flag 8666 to view the statistics objects that the optimizer used to...

A Biography Template for New Presenters

By

Presenting is difficult, and you already know that. It is also incredibly rewarding and...

Goal Progress–Feb 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

Read the latest Blogs

Forums

Problem with creating quri for alocating amount

By Deimos_farm

good day i came a cross of a problem So i have a quri...

Problem with Logic for new column

By kobinarashid

Hi guys, I have the following table DDL/DML CREATE TABLE #DailyOnHandForecast (Id INT, ItemNo_...

pivot on 2 fields

By Bruin

I'm trying to create a query that pivots on 2 fields(entity,channel) and produce a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers