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)

2007-09-09

3,527 reads

Blogs

Stairway to Microsoft Azure SQL Database Part 4 : Azure SQL server , an overview

By

In the last few posts, we were discussing about database deployment model and purchase...

Information Measurement with SQL Server, Part 4.9: The Bregman Divergence

By

By Steve Bolton …………Before closing out this long-delayed segment on stochastic information distances, I...

Let’s Talk About The Cloud

By

I’m launching a new initiative called the Community Circle Cloud Conversation Club (c5 for...

Read the latest Blogs

Forums

Get dates between previous month date and current month date

By Raja Raman S

BI have a requirement to write a query to get all the records between...

Query

By jsshivalik

Hi I have query select T0.DocType,T0.Debit , T1.Credit , T1.account from tbl1 where Mdate...

Daily Coping 29 May 2020

By Steve Jones - SSC Editor

Today’s tip is today link your decisions and choices to your purpose in life....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers