Query to Find ByteSize of All the Tables in SQL Server

1. Query to Find ByteSize of All the Tables in SQL Server :-

SELECT CASE WHEN (GROUPING(sob.name)=1) THEN 'All_Tables'
ELSE ISNULL(sob.name, 'unknown') END AS Table_name,
SUM(sys.length) AS Byte_Length
FROM sysobjects sob, syscolumns sys
WHERE sob.xtype='u' AND sys.id=sob.id
GROUP BY sob.name
WITH CUBE


2.Query to find out all database size along with full details:-

Ans. Sp_helpdb — execute this is master database.

3.Query to find out information of logfile and mdf file of a particular database:-

Ans.sp_helpfile -execute this from the database for which you want to check the log & mdf file.


4.Find out full database size in server :-

SELECT sum((size*8)/1024) SizeMB
FROM sys.master_files
GO



Please share your ideas and opinions about this topic.

If you like this post, then please share with others.
Please subscribe on email for every updates on mail.