finding the blocks in sql server

Hai buddies,The following procedure can be used to find whether there are any blocks in the sql server.The procedure if run in Master database , can be used like any other system stored procedure from any database.The output of the proc will contain the followingSPID OF RUNNING APPLICATIONAPPLICATION NAMEEXECUTING DATABLOCKED (Y/N)BLOCKING SPIDBLOCKING APPLICATIONEXECUTING DATA (BLOCKING […]

3.67 (3)


3,524 reads


Kubernetes Pipelines


This post continues looking at some of the Kubernetes concepts I’ve been learning with...

Top Modern Data Warehouse questions


Below are the top 15 questions I am seeing from customers looking to build...

Importance of Testing


I’ve always said if you’re running a script for the first time in a...

Read the latest Blogs


understanding behavior [with persist_sample_percent=on] on maintenance process.

By fpolhwein

When creating a table [s1].[tmp_t1], inserting some data into same table (~500 rows) from...

Comparing list to only show Names that have not turned in something

By nmoore

I have 2 Data Sets. One that shows The peoples names and when they...

SQL Server Agent stops unexpectedly

By AlphaTangoWhiskey

SQL 2016 Enterprise running on Server 2012 We migrated a lot of ETL jobs...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers