SQL Server – Database Size Growth Summary

Here the SQL Script written for finding the Database size periodically and use it for Power BI desktop to analysis the database size growth periodically to the System admin and management department. Create the table for storing the daily basis database size infromation. CREATE TABLE DatabaseFileSize ( [database_id] INT, [file_id] INT, [file_type_desc] NVARCHAR(120), [name] NVARCHAR(128), [physical_name] NVARCHAR(520),...