Top "Locking" questions

Locking allows different types of resources to be used exclusively by one process at a time.

Find out who is locking a file on a network share

I want to known who is locking a file on a network share. Here is the problem : the network share …

windows locking
How does lock work exactly?

I see that for using objects which are not thread safe we wrap the code with a lock like this: …

c# .net synchronization locking thread-safety
Optimistic vs. Pessimistic locking

I understand the differences between optimistic and pessimistic locking. Now could someone explain to me when I would use either …

sql-server locking optimistic-locking pessimistic-locking
Effect of NOLOCK hint in SELECT statements

I guess the real question is: If I don't care about dirty reads, will adding the with (NOLOCK) hint to …

sql sql-server locking
How to find out what is locking my tables?

I have a SQL table that all of a sudden cannot return data unless I include with (nolock) on the …

sql sql-server sql-server-2008-r2 locking query-optimization
Is there an advantage to use a Synchronized Method instead of a Synchronized Block?

Can any one tell me the advantage of synchronized method over synchronized block with an example?

java multithreading concurrency locking synchronized
Lock, mutex, semaphore... what's the difference?

I've heard these words related to concurrent programming, but what's the difference between them?

concurrency locking mutex semaphore
How to solve SQL Server Error 1222 i.e Unlock a SQL Server table

I am working in a database where I load data in a raw table by a data loader. But today …

sql-server database sql-server-2008-r2 locking deadlock
Any way to select without causing locking in MySQL?

Query: SELECT COUNT(online.account_id) cnt from online; But online table is also modified by an event, so frequently …

mysql locking
Detecting locked tables (locked by LOCK TABLE)

Is there a way to detect locked tables in MySQL? I mean tables locked by the LOCK TABLE table WRITE/…

mysql locking