How to fix - Lock request timeout period exceedd Error 1222

Question: I'm on SSMS and trying to access the SQL Server instance but I'm getting this error: Lock request timeout period exceedd Error 1222 Normally I can access the server and there haven't been any security changes. What could be causing this problem? Answer: The basis of the Error 1222 is that a transactions is holding a lock on the target resource for a longer period than the query could wait for. There are different situations that can trigger the error message. Example 1 : Someone running a transaction with a BEGIN TRAN but no ROLLBACK or COMMIT. The transaction... Read more →

How to spot a SQL Antipattern

Survival in the DBA world is following good practises but just as importantly it is about identifying bad practises. Bad practises can also be called antipatterns. An antipatterns is a standardised fix to a common problem that may lead to a counterproductive outcome. There is a well known book – AntiPatterns: Refactoring Software, Architectures, and Projects in Crisis – where this term was first coined. The authors highlighted two criteria required to satisfy a fix as an antipattern A commonly used fix or solution , which may appear to solve the issue , but tends to bad consequences. A simple... Read more →