Pages

Saturday, September 21, 2013

SQL SERVER – 2005 Locking Hints and Examples | Journey to SQL Authority with Pinal Dave

Locking Hints and Examples are as follows. The usage of them is same same but effect is different. ROWLOCK Use row-level locks when reading or modifying data. PAGLOCK Use page-level locks when reading or modifying data. TABLOCK Use a table lock when reading or modifying data. DBLOCK Use a database lock when reading or modifying… Continue Reading...

Source: SQL SERVER – 2005 Locking Hints and Examples | Journey to SQL Authority with Pinal Dave