ORDERBYt1.FT,t1.DBN,t1.FNM;

Ctrl+5 - Size of all files of all databases on SQL Server instance:

INSERTINTO@t(DBN,FNM,PFNM,Size,Used)

EXECsp_msforeachdb@command1="use [?] SELECT '?' as
DB_Name,Name,physical_name,size,FILEPROPERTY(name, 'SpaceUsed') US FROM
sys.database_files;"

SELECT

DBNas"Database Name",

FNMas"File Name",

PFNMas"Physical Name",

ROUND(Size/128.,3)asSizeMB,

ROUND(Used/128,3)ASUsedSpaceMB

FROM@t

ORDERBYDBN,FNM;

Ctrl+6 - List of all currently running sessions with texts of queries and batch, execution plan, execution time, blocking processes, blocking resources, used memory, host name, etc. full replacement of SP_WHO2: