Script to kill the top blocker and report what it was doing.

This script identifies the blocking locks at the top of the blocking chain and kills them. Specifically, it reports what the top blocking spids are doing, kills them, waits three seconds and then reports on current blocking status.  If you have a situation where single connections are causing a huge blocking chain and you want […]

4.75 (4)

2003-05-12

2,531 reads

Blogs

Deploy BACPAC to Azure Managed Instance failing from SSMS?

By

Recently I ran into an error when trying to copy a small database bacpac...

Daily Coping–3 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Data Céilí 2020 Cancelled

By

Yesterday we announced that Data Céilí 2020 has been cancelled due to the continuing...

Read the latest Blogs

Forums

Need T-SQL to list all tables in database that 'qualify' for Compression

By VoldemarG

Does anyone know of any existing script that would allow me to list all...

Basic SQL Question

By porterdl

I am new to SQL and I am having a hard time finding resources...

Delet old backup in azure

By abdalah.mehdoini

Hello, How to delete backups in blob storage from azure sql server VM to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers