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

Blogs

InvalidAbfsRestOperationException in Azure Synapse notebook

By

Problem The first issue that developers in my team noticed was when they tried...

What do we want to achieve by encrypting our data?

By

On the face of it, this is a very obvious question with a very...

Daily Coping 5 Dec 2022

By

Today’s coping tip is to look for new reasons to be hopeful, even in...

Read the latest Blogs

Forums

log shipping restore from primary server backup directory

By sqlfriend

To understand the concept of transaction log shipping, in below case, will it work:...

Optimization for Single Table with Thousands of Concurrent Updates

By keith.west-982594

I have a table with 5 million records and each record requires a "Value"...

Pivot not working, pivot without aggregate functions.

By sbhagyalakshmi95

Hi Team,   Can you please help me to get data pivot data. my...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers