StingyJack

  • Interests: Music, Animals, Computers.

Technical Article

sp_what

This is a replacement for SP_who and modification of sp_who2. It will always list only active, nonsystem processes, and will list the number of seconds a transaction has been running for. Some transactions do not report a last batch time, so I forced a large value to display so you can see any issue with […]

5 (1)

You rated this post out of 5. Change rating

2006-10-02 (first published: )

2,274 reads

Blogs

Using T-SQL Snapshot Backup - Are Snapshots Backups?

By

Introduction Traditional SQL Server backups can struggle with large databases, resulting in longer backup...

Developer Q&A: Dika Fei of Jelly Pixel Studio

By

"Let me know where you get your magic pixie dust from!"

A New Word: Flashover

By

flashover – n. the moment a conversation becomes alive and real, when a spark...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

It's Time to Play

By Ryan Booz

Comments posted to this topic are about the item It's Time to Play

Call Dates Effective Range

By Yash34

Hi Everyone, I have the data in the below form : Desired output: Here...

Visit the forum

Question of the Day

Synapse Analytics History III

What was the originally name of the appliance that eventually became Azure Synapse Analyics?

See possible answers