I have a Microsoft SQL Server 2017 Express Edition those have a size limit of 10240MB (10Gigs) and I am not sure how I can check how much space I have left in this license. I have tried the following:
SELECT DB_NAME(database_id) AS database_name, type_desc, name AS FileName, size/128.0 AS CurrentSizeMB FROM sys.master_files WHERE DB_NAME(database_id) = 'DemoDB' AND type IN (0,1);
This outputs the following:
Is it the upper value
10229.687500 or do I need to use another query?