Learn how to use FILEPROPERTY to check for free space in a database.
SELECT DB_NAME() AS DBName, name AS FileName, size/128.0 AS MB, size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS FreeMB FROM sys.database_files;
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
