Here are the two ways to find the size of a SQL Server table
1-- Right Click on the table and then go to the Properties. Then Click on Storage Tab and you will be able to see the size of Table
Fig 1-SQL Server Table Size by using Table Properties
2- OR we can use sp_spaceused system Stored Procedure to find the size of a SQL Server table.
sp_spaceused Stored Procedure return the size of a table in KB, to get the Size in MB, we can divide with 1024.
8952/1024=8.742187 MB
1-- Right Click on the table and then go to the Properties. Then Click on Storage Tab and you will be able to see the size of Table
2- OR we can use sp_spaceused system Stored Procedure to find the size of a SQL Server table.
EXEC sp_spaceused 'TableName'
Fig 2- Find the Size of Table by using sp_spaceused Stored Procedure
sp_spaceused Stored Procedure return the size of a table in KB, to get the Size in MB, we can divide with 1024.
8952/1024=8.742187 MB
how can find row size for particular rang in single table on sql server 2017.
ReplyDeletefor eg: ABD table having 1 lack rows with 100 GB. need find row size for 5000 row in ABC table.