Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by
  • When: 19 Jun 2013 11:54 PM
  • Last revision by (eMicrosoft Partne)
  • When: 20 Jun 2013 8:09 AM
  • Revisions: 6
  • Comments: 1
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  T-SQL: Table Sizes in SQL Server

T-SQL: Table Sizes in SQL Server

T-SQL: Table Sizes in SQL Server

--one table
sp_spaceused 'TABLE_NAME'

--all tables
EXEC sp_MSforeachtable 'EXEC sp_spaceused ''?'''

--OR

IF OBJECT_ID('tempdb..#TableSize') IS NOT NULL
DROP TABLE #TableSize
CREATE TABLE #TableSize
(
SEQ INT IDENTITY(1,1) ,
name NVARCHAR(200),
rows BIGINT,
reserved VARCHAR(100),
data VARCHAR(100),
index_size VARCHAR(100),
unused VARCHAR(100)
)

INSERT #TableSize
EXEC sp_MSforeachtable 'EXEC sp_spaceused ''?'''
SELECT* FROM #TableSize

 

, , , [Edit tags]
Leave a Comment
  • Please add 3 and 6 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 20 Jun 2013 8:09 AM

    Naomi  N edited Revision 4. Comment: Title change

Page 1 of 1 (1 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 20 Jun 2013 8:09 AM

    Naomi  N edited Revision 4. Comment: Title change

Page 1 of 1 (1 items)