Eric Wahner


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,425 reads

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,559 reads

Blogs

The Second Annual, Official WordPress.com Growth Summit is Coming and You Won’t Want to Miss It

By

Join us August 17 (Americas) or August 18 (Asia-Pacific). Register today!

The Post Pandemic Office Experience

By

I traveled to Pasadena, CA this week to work with a few other Redgaters...

Connecting to Azure Blobs in Power BI

By

The step-by-step process below walks through connecting to data housed in Azure Blob Storage...

Read the latest Blogs

Forums

Get the last day of the year based on a date range

By dqurve

I am trying to get the last day of the year from a date...

Put two queries together

By stephen.aa

Hello: Right now I have two queries as shown below: SELECT D.DocumentID AS [Document...

Excel Formula to create SQL Script for a Values Table

By allinadazework

Comments posted to this topic are about the item Excel Formula to create SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers