Listing 1: Query That Shows the Original and Current Size of all Files in Tempdb
SELECT
	alt.filename
	,alt.name
	,alt.size * 8.0 / 1024.0 AS originalsize_MB
	,files.size * 8.0 / 1024.0 AS currentsize_MB
FROM
	master.dbo.sysaltfiles alt INNER JOIN tempdb.dbo.sysfiles files ON
		alt.fileid = files.fileid
WHERE
	dbid = db_id('tempdb')
	AND alt.size <> files.size