Skip to content
  • Home
  • SteamDeck
  • Linux
  • SQL-Server
  • PowerShell
  • Oracle
Schelstraete.orgSchelstraete.org
SCHELSTRAETE.ORG

I.T. minded

  • Home
  • SteamDeck
  • Linux
  • SQL-Server
  • PowerShell
  • Oracle
LinkedIn Email
Schelstraete.orgSchelstraete.org
SCHELSTRAETE.ORG

I.T. minded

T-SQL: Show sizes of all tables in a database

  • BartBart
  • February 11, 2019
  • SQL-Server

You can use the t-sql code below in order display the size of each table in a specific database.

use MY_DATABASE_NAME
go
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"
go
Share your love
Bart
Bart
Articles: 100
T-SQL-Commands
Previous Post T-SQL: Kill all connections to a specific database
Next Post T-SQL: Find table in complete instance
T-SQL-Commands
No results

Recent Posts

  • Steam Deck: Hogwarts Legacy performance
  • T-SQL: Check cpu usage SQL statements
  • Steam Deck: Transfer files from Windows to Deck
  • PowerShell: Check TLS version
  • T-SQL: Identify queries that consume a large amount of log space

Archives

  • February 2023
  • December 2022
  • January 2022
  • December 2021
  • October 2021
  • September 2021
  • July 2020
  • March 2020
  • February 2020
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • February 2019
  • November 2017
  • August 2017
  • July 2017
  • June 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016

Categories

  • Avamar
  • General
  • Ispconfig
  • Linux
  • Oracle
  • PowerShell
  • SAP Hana
  • SQL-Server
  • SteamDeck
  • Uncategorized
Related Articles
T-SQL-Commands

T-SQL: Check cpu usage SQL statements

  • Bart
  • February 17, 2023
T-SQL-Commands

T-SQL: Identify queries that consume a large amount of log space

  • Bart
  • February 14, 2023
T-SQL-Commands

T-SQL: Shrink incremental

  • Bart
  • December 28, 2022

Copyright © 2023 Schelstraete.org

Add Schelstraete.org as app.

ADD