--Set deadlock priority to high to make sure the script is not stopped due to deadlock SET DEADLOCK_PRIORITY HIGH --<numeric-priority>...

--Find log_reuse_wait_desc wait type for the database: DB_Name select log_reuse_wait_desc from sys.databases where name='DB_Name'

--Note: Check is required if you want to remove log file. Only Secondary log file and data file can be removed. checkpoint go USE...

--List of tables with CDC enabled SELECT s.name AS Schema_Name, tb.name AS Table_Name , tb.object_id, tb.type, tb.type_desc,...

--Find Orphan Users in the DB EXEC sp_change_users_login 'Report' --If you already have a login created, map the user to login using the...

SQL Server Script to Change DB Owner to SA for all the user DBs in the Instance. --Script:17 Change DB Owner to SA for all the User DBs...

Learn how to configure DTC

T-SQL Script to Log Shipping Database. Pre-req. Check List: Database should be in Full recovery mode. Take Full database back on the...

Learn how to configure SQL Server database mirroring using T-SQL Script.

SQL 2019 has a new feature name: ADR Accelerated Database Recovery. To enable ADR at database level: alter database wideworldimportersdw...

select top 10 * from sys.fn_dblog(null,null) order by [Current LSN] desc go

--Script:16 SQL Server 2019 and Above. Find DB and Object name having Page_latch Wait type. --You can use the following script as an...

clear #Install-Module ImportExcel #output file location: c:\powershell\Report_PROD_.xlsx #Input File C:\powershell\sqlservers.txt...

SET ANSI_NULLS ON; SET ARITHABORT ON; SET QUOTED_IDENTIFIER ON; SET NOCOUNT ON; Declare @dbname varchar(max) DECLARE @command...

1). Script to see what is running in your SQL Server. select * from sys.sysprocesses where status = 'suspended' and spid >10 and hostname...

SELECT OBJECT_NAME(s.[object_id]) AS [ObjectName], i.name AS [IndexName], i.index_id, s.user_updates AS [Writes], user_seeks + user_scans...

SELECT OBJECT_NAME(s.[object_id]) AS [ObjectName], i.name AS [IndexName], i.index_id, user_seeks + user_scans + user_lookups AS [Reads],...

-- When were Statistics last updated on all indexes? SELECT o.name, i.name AS [Index Name], STATS_DATE(i.[object_id], i.index_id) AS...

-- Breaks down buffers used by current database by object (table, index) in the buffer cache SELECT OBJECT_NAME(p.[object_id]) AS...

-- Find missing index warnings for cached plans in the current database -- Note: This query could take some time on a busy instance...