How to convert sys.master_files size column into GB

(Jack Vamvas) Question: I need to convert the sys.master_files size column into GB. Currently when I run select name,size from sys.master_files I get back the file size as KB. I’ve tried doing something – size/1024/1024 – but I’m getting incorrect results

Register to Read