Lesson Learned #471: Why Can't I Expand the Database Table List from my Application?
In the dynamic world of database management, we encounter unique challenges that impact the efficiency and performance of our applications. A common issue observed is the inability to expand the database table list during certain operations. This article addresses a specific situation where clients launch resource-intensive queries that take time and create locks, preventing other users from expanding the table list.Lesson Learned #319: Lock request time out period exceeded using SSMS
Today, we got a service request that our customer got the following error message:Lock request time out period exceeded. (.Net SqlClient Data Provider) using SQL Server Management Studio. Following I would like to share with you some details about this issue and how to find and fix it.
