Windows Explorer status bar offers rich information about the files being viewed. For any video file, Windows shows the length of the video in the status bar along with the size, date created and other attributes.
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