Skip to content

Find a column in a SQL Server Database

use [XYZ] — your database name go select name, type_desc from sys.all_objects where object_id in (select object_id from sys.all_columns where upper(name)='<your column name>’) go

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…