CODEWITHSUNDEEP
sql-serverdatabasesql-server-2014
Water Cooler v2
Water Cooler v2

Reputation: 33850

How do I see which table has taken up how much storage space?

How do I see which table has taken up how much storage space in Microsoft SQL Server 2014?

Upvotes: 2

Views: 3878

Answers (2)

Mukesh Arora
Mukesh Arora

Reputation: 1813

If you want to check space used by a particular table then you can use the below query

Single Table

EXEC sp_spaceused N'yourtableName'
 GO

For all the tables 

sp_msforeachtable 'EXEC sp_spaceused [?]' 
GO

Upvotes: 3

Greg
Greg

Reputation: 4045

Simplest way -> In SSMS's Object Explorer, right-click on the database, select Reports -> Standard Reports -> Disk Usage by Table.

Another simple way -> In SSMS, launch Object Explorer Details, drill down to a table, and select it. In the results pane, you'll see the size of that table.

Upvotes: 5

Related Questions