Some unknown facts about Update (U) lock(sqlreality.com)

submitted by subhashpunia(35) 2 years, 3 months ago

Update lock is “Waiting exclusive lock” and is used not only for UPDATE statements but also for DELETE statements. Know more facts in this post. read more...

add a comment |category: Database |Views: 3

tags: Database another

In MS SQL Server getting Deadlock details using Traces(sqlreality.com)

submitted by subhashpunia(35) 2 years, 3 months ago

To get complete deadlock details the easiest and lighted-waighted method is using Traces#. For this purpose SQL Server have Trace # 1204, 1205. The information can be logged in Error log file using trace #3605. read more...

add a comment |category: Database |Views: 17

tags: Database another

Index improve performance by reducing blocking(sqlreality.com)

submitted by subhashpunia(35) 2 years, 3 months ago

Reduced number of comparison is not the only reason for performance improvement because of indexes. Indexes also reduce the blocking and that reduces that waiting time. read more...

add a comment |category: Database |Views: 7

tags: Database another

Life time or age of a Share Exclusive and Update lock in SQL Server(sqlreality.com)

submitted by subhashpunia(35) 2 years, 3 months ago

Age of shared lock is decided by the isolation level of session. Age of exclusive locks and update locks is always the length of outermost user defined transaction. There is no impact of isolation levels on the life time of these locks. read more...

add a comment |category: Database |Views: 3

tags: Database another