T-SQL to show database sizes on a SQL Server

I found this handy little query at this site. http://www.siusic.com/wphchen/t-sql-query-to-get-database-size-325.html Fantastic query if you want to do a quick pie graph showing the dispersement of your database sizes. use master declare @PageSize varchar(10) select @PageSize=v.low/1024.0 from master..spt_values v where v.number=1 and v.type=’E’ select name as DatabaseName, convert(float,null) as Size into #tem From sysdatabases where dbid>4…

Continue reading →