When executed against a database in which blocking occur, below script will report lockType, Object waited for and current Wait times. The script requires access to master..systables. The script queries syslockInfo (as does sp_lock), but further joins sysprocesses with an interpretation of waitresource matching SQL Server 7.0 and SQL Server 2000.
2002-01-14
2,576 reads
By Brian Kelley
It tells us to take the time to master the foundational basics of whatever...
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
hi i need "sample size" in my report's 4th data region which is a...
Hello experts, I want to be more organized about the SSL certificates we have...
Hi everyone, We recently upgraded our server to Sql Server 2019 (15.0.2125.1 (X64) on...
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers