Home Forums SQL Server 2008 T-SQL (SS2K8) Convert sys.master_files size column to GB? RE: Convert sys.master_files size column to GB?
Lynn Pettis
SSC Guru
Points: 442467
More actions
June 7, 2014 at 5:58 pm
#1719931
Welsh Corgi (6/7/2014)That is sweet. I have the sizes stored in KB's. What statement could I used to convert from KB to GB?Thanks a bunch!
Welsh Corgi (6/7/2014)
Thanks a bunch!
Divide twice by 1024.0.