StingyJack

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)

2006-10-02 (first published: )

2,010 reads

Blogs

Azure Data Studeo- Nov 2019 Release

By

SQL Server Management studio is now can be installed separately not part of SQL...

Azure Synapse Analytics new features

By

Almost lost in all the announcements from Ignite was a bunch of amazing new...

Docker, Git and DBATools

By

For those who don’t know, last week was the PASS Summit. It’s an amazing...

Read the latest Blogs

Forums

SQL'De Yedek alirken %90 da hata veriyor ve mdf dosyasi erisilemez diyor

By erdogan

Hi Friends, I'm using SQL 2014, Everything works fine I gave the following error...

Basic Avaialbility setup but replicas went to resolving mode

By pols

Hi, I configured the Basic Alwayson setup in two of the test SQL standard...

I am looking to optimize this T-SQL Statement (it generates very High Reads..)

By VoldemarG

  In the below SQL statement (also attached as DOC file) it has been...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers