Patching up leading zeroes
UPDATE TheTable
set FILE_NBR = replicate('0', 6-len(FILE_NBR) ) + FILE_NBR
Querying disk file sizes
use master
SELECT DB_NAME(DATABASE_ID) AS [DATABASE_NAME], name as FileName, Type_desc,
-- hmmmm 8k blocks?
CAST(( CAST(SIZE * 8 AS FLOAT) ) / 1024 AS VARCHAR) + ' MB' AS [SIZE],
CAST( (MAX_SIZE / 128) AS VARCHAR) + ' MB' AS [MAX_SIZE]
FROM SYS.MASTER_FILES
...