sp_helpuser SELECT * FROM sys.database_principals SELECT loginname FROM syslogins where loginname like ‘%NAME%’ EXEC sp_helplogins

ctrl-F6

exec sp_msforeachdb ‘use [?]; select [DBName]=”?”, ds.* from sys.data_spaces ds where type=”FD”’

— Locking select cmd,* from sys.sysprocesses where blocked > 0 SELECT command, s.text, start_time, percent_complete, CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as varchar) + ‘ hour(s), ‘ + CAST((DATEDIFF(s,start_time,GetDate())%3600)/60 as varchar) + ‘min, ‘ + CAST((DATEDIFF(s,start_time,GetDate())%60) as varchar) + ‘… 

How to add a subtotal row in sql This comes from: http://stackoverflow.com/questions/19387650/how-to-add-a-subtotal-row-in-sql Name Score A 2 B 3 A 1 B 3 Name Score A 2 A 1 Subtotal 3 B 3 B 3 Subtotal… 

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N’Database Name’ GO USE [master] GO DROP DATABASE [Database Name] GO

SELECT CONVERT(CHAR(100), SERVERPROPERTY(‘Servername’)) AS Server, msdb.dbo.backupset.database_name, msdb.dbo.backupset.backup_start_date, msdb.dbo.backupset.backup_finish_date, msdb.dbo.backupset.expiration_date, CASE msdb..backupset.type WHEN ‘D’ THEN ‘Database’ WHEN ‘L’ THEN ‘Log’ WHEN ‘I’ THEN ‘Differential Database’ WHEN ‘F’ THEN ‘File or filegroup’ WHEN ‘G’ THEN ‘Differential file’… 

Links to articles: Performance Troubleshooting Methodology