SQL Server is no exception. However, it often leads to three common phenomena – locks, blocks, and deadlocks. SQL Diagnostic Manager SQL Server
SQL SERVER – NOLOCK with DMVs
Is it alright to use NOLOCK with DMVs? I was recently asked about this by a client during the Comprehensive Database Performance Health Check.
SQL SERVER – Reduce Deadlock for Important Transactions With Minimum Code Change
They had one transaction which was often the victim of deadlock. Today how to Reduce Deadlock for Important Transactions With Minimum Code Change.
Does NOLOCK Really Applies No Lock? – Interview Question of the Week #209
Question: Does NOLOCK Really Applies No Lock?
Answer: The answer is NOLOCK do apply the lock and it is Sch-S lock. Sch-S stands for Schema Stability. Quite a few people say it is actually Schema Shared lock and it is not correct.
SQL SERVER – 3 Different Usage of DBCC SQLPERF
Have you ever wondered what does DBCC SQLPERF do in SQL Server?
SQL SERVER – FIX – Property IsLocked is Not Available for Login
I play and experiment with SQL Server to the max. Sometimes I am not sure what I did and I land into something undesired. Then the reason to troubleshoot starts and I get to learn something new. Sometimes these learnings are based on error messages that you folks send me.…
Read More