Find folder size in SQL Server

T-SQL

EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'xp_cmdshell', 1
EXEC xp_cmdshell N'dir C:\'

That’s It.
Enjoy Learning.