Insomnia can be caused by psychiatric conditions such as depression. Psychological struggles can make it hard to sleep, insomnia itself can bring on changes in mood, and shifts in hormones and physiology can lead to both psychiatric issues and insomnia at the same time.
A lock is a variable associated with a data item that describes the status of the item with respect to possible operations that can be applied to it. Generally, there is one lock for each data item in the database.Locks are used as a means of synchronizing the access by concurrent transactions to the database item. Types of Locks. Several types of locks are used in concurrency control.inary Locks. A binary lock can have two states or values: locked and unlocked. A distinct lock is associated with each database item A. If the value of the lock on A is 1, item A cannot be accessed by a database operation that requests the item.
Lock Granularity. 1  SQL Server can lock resources at the table, page, partition or row level. 2  If locks are escalated, SQL Server can also lock a single partition of a table or index. 3  SQL Server can also lock index keys and ranges of index keys if needed. Intent Locks. 2  As the name suggests is a pre-qualifiers to shared/update/exclusive locks. 3  Since SQL Server can acquire locks at different levels, before the process completes or the statements completes SQL Server might want to know if locks are already acquired.