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.

Nenhum comentário:

Postar um comentário

Related Posts Plugin for WordPress, Blogger...