Close
Menu
Want to work with us? We're on the lookout for digital experts.
We're hiring
02 February 2012
by Web Bureau
Total database size script
SELECT [SpaceUsed(KB)] = SUM(alloc.used_pages)*8 FROM sys.objects obj JOIN sys.indexes idx on obj.object_id = idx.object_id JOIN sys.partitions prt on obj.object_id = prt.object_id JOIN sys.allocation_units alloc on alloc.container_id = prt.partition_id WHERE obj.type = 'U' AND idx.index_id IN (0, 1)
This site uses essential cookies for parts of the site to operate and have already been set. Find out more about how we use cookies and how you may delete them. You may delete cookies, but parts of the site will not work.