Eric Wahner


Technical Article

Who's Blocking

A quick little standalone script that tells you what process is blocking and what processes the blocking processing actually blocking.When running this script in QA, change your output to "Results in Text" ( CTRL-T ).  Utilizes the blocking info in sp_who2 combined with dbcc inputbuffer and a little cursor to wrap it all up.  Formatting […]

2.33 (3)

2007-04-19 (first published: )

7,431 reads

Technical Article

What's Running

spWhatsRunning does just that.  It tells you exactly what is executing on your server.  By combining the output of the sp_who and dbcc inputbuffer, this script will tell you exactly whats being executed.  DBCC INPUTBUFFER will tell you the same thing, but by the time you get the spid, the offending process may be gone.  […]

2007-04-17 (first published: )

2,674 reads

Blogs

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Why Managed Identities are Awesome

By

For the first workdays of this new year, I had the pleasurable task of...

Read the latest Blogs

Forums

Dimensional table and Stored Procedure

By yrstruly

To meet these requirements below, I came up with this SQL. Please evaluate my...

Anderson-Darling Calculation

By jackdanny816

Hi   I am following an article posted on sql server central on the...

Use of an NCI - that does not contain the Column required.

By SteveOC

Hello. I am a bit confused and not sure what terms to use to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers