Skip to content

Get Size of all tables in a SQL Server Database

use [<dbname>] go SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(a.used_pages) * 8 AS UsedSpaceKB, (SUM(a.total_pages) – SUM(a.used_pages)) * 8 AS UnusedSpaceKB FROM sys.tables t INNER JOIN… 

Launch Admin Tools from Windows Command Line

Many of the Windows admin tools can be quickly accessed by launching them from an administrator command prompt. AD Domains and Trusts domain.msc Active Directory Management admgmt.msc AD Sites and Serrvices dssite.msc AD Users and…