Technical Article

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)

You rated this post out of 5. Change rating

2003-05-12

4,394 reads

Blogs

Cyber Scams and Operation Shamrock

By

Erin West gave the keynote for the 2025 Techno Security & Digital Forensics East...

The Book of Redgate: Ingeniously Simple

By

Redgate has been known for many useful tools that are easy to use. We’ve...

Building a Todo List RESTful API in C++ with Docker, GitHub Actions, Azure ACR: A Beginner’s Guide

By

C++ is a highly versatile language for developing console applications, batch processing, and performance-critical...

Read the latest Blogs

Forums

BULK INSERT messing up import of CSV file with a comma in it

By water490

Hi everyone I am using BULK INSERT to load a CSV.  I have noticed...

Users Default Schema in a stored procedure.

By Michael L John

One of our systems contains data for multiple organizations.  OrgA should not be able...

Calculating Difference between Multiple Dates for a Given Condition in HH:MM:SS

By satnam.singh 44358

We have the following requirement:- Event_Time                 ...

Visit the forum

Question of the Day

Updating a Data API Builder Connection String

Can I use dab update to update a connection string in my Data API Builder configuration file?

See possible answers